OraFAQ Forum: SQL & PL/SQL » Insert data in diff schema

Home » SQL & PL/SQL » SQL & PL/SQL » Insert data in diff schema

Mon, 09 June 2008 00:28

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?

Mon, 09 June 2008 00:39

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

insert into mytable (select ... from otherschema.othertable)

Regards
Michel

Mon, 09 June 2008 00:40

Frank
Messages: 7901
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?

Mon, 09 June 2008 03:21

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: Thu Dec 05 01:30:46 CST 2024