OraFAQ Forum: SQL & PL/SQL » create new record based on old...

Home » SQL & PL/SQL » SQL & PL/SQL » create new record based on old...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create new record based on old... [message #19171]

Mon, 04 March 2002 06:08

Jared
Messages: 10
Registered: June 2001

Junior Member

I need to create a new record in a table with all the same data as an existing record (except for a new unique primary key value). Can I do this with one line in SQL? Thanks in advance!

Jared

Report message to a moderator

Re: create new record based on old... [message #19172 is a reply to message #19171]

Mon, 04 March 2002 06:27

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

yep u can.

insert into your table_name
select new_primary_key,column_list......
where ......restriction goes here......

Report message to a moderator

Re: create new record based on old... [message #19175 is a reply to message #19171]

Mon, 04 March 2002 06:50

Jared
Messages: 10
Registered: June 2001

Junior Member

Is there a way to do this without listing out all the column names??

Like,

insert into table1 AS SELECT * from table1 where ID = X

and then somehow change the key within this statement?

Report message to a moderator