SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert row to a table from a rowtype record?

JackKOct 19 2010 — edited Oct 19 2010

I have a record:

subtype dt1_t is POD_SRTR_DT1%ROWTYPE;
dt1  dt1;

I tried then insert a record to the table:

insert into POD_SRTR_DT1 select * from table(dt1);

but this doesn't work because dt1 is not a nested table type. How can I insert the row to the table?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2010

Added on Oct 19 2010

6 comments

1,612 views