insert into ... select ...
Posted by:
Ron Savage
Date: November 18, 2004 09:39PM
In manual for V 4.1.7, section 14.1.4.1 it says:
INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column_list)]
SELECT ...
it doesn't actually say you can or can't select from a table in another db.
My experiments say it can't be done.
So:
insert into $t select * from other_db.$t
doesn't work.
This needs to be clarified.
And why can't it be done :-)?
Subject
Views
Written By
Posted
insert into ... select ...
11008
November 18, 2004 09:39PM
4187
November 18, 2004 10:11PM
4073
January 18, 2005 12:20PM
3778
January 18, 2005 03:44PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.