OraFAQ Forum: SQL & PL/SQL » how to copy and insert all the values in a tuple that is having auto ID

Home » SQL & PL/SQL » SQL & PL/SQL » how to copy and insert all the values in a tuple that is having auto ID

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

how to copy and insert all the values in a tuple that is having auto ID [message #865]

Sat, 09 March 2002 17:00

pranavi
Messages: 3
Registered: February 2002

Junior Member

I have a table "Accountpay" with 50 field names.
every row has AUTO ID(primary key) (automatically generates the ID ).
I wanna copy all the field names in that table and insert them in the same table. but I am getting problem with the AUTO ID.

I am using this sql
insert into Accountpay
values( select * from Accountpay where columnname = '123')

Report message to a moderator

Re: how to copy and insert all the values in a tuple that is having auto ID [message #882 is a reply to message #865]

Mon, 11 March 2002 00:49

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

try this

insert into Accountpay(......column_list without the ID column.....)
values( select ......column_list without the ID column..... from Accountpay where columnname = '123')

Report message to a moderator

Previous Topic:	handling the length of musical pieces
Next Topic:	Auto 'exp' during time interval

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 18:45:51 CDT 2024