Home » SQL & PL/SQL » SQL & PL/SQL » sql statement help
sql statement help [message #18553] Tue, 05 February 2002 06:32 Go to next message
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') )
/
Re: sql statement help [message #18566 is a reply to message #18553] Tue, 05 February 2002 08:52 Go to previous message
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') )
Previous Topic: where and which copy of Oracle can I get to practice PL/SQL with?
Next Topic: Time field creation
Goto Forum:
  


Current Time: Sat Sep 25 00:52:01 CDT 2021