Home » SQL & PL/SQL » SQL & PL/SQL » Insert data in diff schema
Insert data in diff schema [message #325807] Mon, 09 June 2008 00:28 Go to next message
navaneetha
Messages: 5
Registered: April 2008
Location: hyderabad
Junior Member
hi,
I want to isnert some rows in a table which is in different scehma.how can I do that?
Re: Insert data in diff schema [message #325809 is a reply to message #325807] Mon, 09 June 2008 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
insert into mytable (select ... from otherschema.othertable)

Regards
Michel
Re: Insert data in diff schema [message #325810 is a reply to message #325807] Mon, 09 June 2008 00:40 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I suppose you searched for this. What did you find so far?
How would you select from another user's table?
Re: Insert data in diff schema [message #325846 is a reply to message #325807] Mon, 09 June 2008 03:21 Go to previous message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
I think you are searching for this:
INSERT INTO schema.table(...) VALUES(...);
Previous Topic: How to get source code for the materalized view created
Next Topic: Retrieving a primary key
Goto Forum:
  


Current Time: Sun Dec 04 06:28:44 CST 2016

Total time taken to generate the page: 0.14028 seconds