OraFAQ Forum: SQL & PL/SQL » sql statement help

Home » SQL & PL/SQL » SQL & PL/SQL » sql statement help

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

sql statement help [message #18553]

Tue, 05 February 2002 06:32

Joan
Messages: 36
Registered: February 2002

Member

this is the situation . I have a table with two user _id eg usera and userb. usera has all the information but userb does not. I want to copy all the information from usera to userb
This statement does not work
insert into member_parent_user_security where user_id =upper('&1')
( select * from member_access_parent_user_security where user_id = upper('&2') )
/

Report message to a moderator

Re: sql statement help [message #18566 is a reply to message #18553]

Tue, 05 February 2002 08:52

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

insert into member_parent_user_security ( select * from member_access_parent_user_security where user_id = upper('&2') )

Report message to a moderator

Previous Topic:	where and which copy of Oracle can I get to practice PL/SQL with?
Next Topic:	Time field creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 04:33:51 CDT 2023