Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Insert into the same table with the new column values

626653Sep 17 2009 — edited Sep 17 2009
Hi,

I like to insert into the same table with the with new effective date and new value for one column.
For Instance:

If table ABC contains columsn UNIT
,UNION
,EFFDT
,PLAN
,GRADE
,STEP )
Il need to insert new values for UNIT and EFFDT but the remaining values could be same for columns PLAN, GRADE, STEP. I like to have a statement to select the colums from the same table and insert into the same table. Please let me know how to write sql statement for oracle.
Thanks in advance.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 15 2009
Added on Sep 17 2009
#column, #insert, #table, #with
12 comments
11,221 views