Programming/
 Tools

      Oracle
      JavaScript
      C#

 Fun Stuff
      Music
      Martial Arts
      Robotech

 Other
      Main


DISCLAIMER
This disclaimer is intended to cover all software/freeware, and other various files which are downloadable through or from this site.
Joe Garrepy, isp, and web host can not be held responsible for any software downloaded from this site. All freeware is downloaded at your own risk. Software which is listed on this site is assumed to work properly, but may or may not have different effects on different computer systems. The same rules apply to these programs. Joe Garrepy assumes no responsibility for those unusual occurrences where software has adverse effects on users computer. Joe Garrepy does not warrant these programs/files, and as such, can offer no guidelines in which to use them. All freeware/software/files, trademarks, service marks, and copyrights are acknowledged as belonging to their owners. Any of these which the owner wishes to be removed will be done so immediately. By downloading any software or viewing pages in which software can be downloaded, you agree to be bound to this agreement.

JoeGarrepy.com Oracle Nested Tables Example

Another new feature of Oracle is the ability to build Nested Tables or tables that have columns that are tables. This is neat because you can build a relational data structure inside of one table. The example below builds a table called ENTITY. The data stored in this table traditionally would have to be stored in 4 different tables (base entity table, a repeating name table, a repeating person data table and a repeating employment data table). Instead only the base entity table exists with its children as columns nested inside of it. The script below not only creates a table with multiple nested tables as columns but shows how to select from it and perform DML on the table and precision DML on the nested tables.

SQL Script


If you find any bugs or want to contact me I can be reached @ doughjoe77@hotmail.com.