Re: [SQL] update on nested table of substitutable value

Antonio 6sette wrote:
> I have a table 'dipendenti' with a substitutable column of object:
>
> SQL> desc dipendenti
> Name Null? Type
> ----------------------------------------- -------- -----------------------
> ID NOT NULL NUMBER(4)
> NOME VARCHAR2(30)
> DESCR VARCHAR2(30)
> ...
> DIP_VAR DIP_VAR_TYPE
>
>
> the dip_var_type is:
>
> SQL> desc dip_var_type
> dip_var_type TABLE OF DIP_VAR_SUPER
> DIP_VAR_SUPER is NOT FINAL
> DIP_VAR_SUPER is NOT INSTANTIABLE
> Name Null? Type
> ----------------------------------------- -------- ----------------------
> ID NUMBER(38)
> ....
> UTENTE VARCHAR2(20)
>
> and i have four type of objects UNDER dip_var_super ...

This might be a good place to note that Tom Kyte, and others, have made persuasive arguments against creating tables such as this but rather suggest relational tables and creating object views. You might wish to explore this option.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)