Method Basics

The creation of a type automatically creates a method (constructor) to populate the type. To call the method the original type name is used. The constructor is never called implicitly but must be called explicitly. The constructor can be used anywhere a function call is used. Here is an example insert into the employee_info table.

insert into employee_info

values(1,name_t('Michael','Ault','R'),   <--- Note use of the name_t constructor method

dependent_list(    <--- Note use of dependent_list constructor method to build insert array    

dependent_t('Wife',name_t('Susan','Ault','K'),'39'), <---- Note use of dependent_t method      

 dependent_t('Daughter',name_t('Marie','Ault','C'),23),              

dependent_t('Daughter',name_t('Michelle','Ault','E'),19))

  6* );

Notice that the format for using the constructor methods walk down the type tree. In this case the type tree for the dependent type looks like so:

dependents      <---- Attribute in table

                      dependent_list      <----- Nested Table Type

                                                    dependent_t       <----- Base Type

SEE CODE DEPOT FOR FULL SCRIPTS

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.  You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.