insert into select & datatypes?
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 May 2005 16:40:07 -0400
Anyone no if any/all Oracle datatypes that are NOT supported by "insert into
select...".
How about "insert into select...from t1@dblink" over db link?
insert into SCOTT.B_[LOB_TABLE | XMLTYPE_TABLE | USERDEFINEDTYPE_TABLE |
LONG_TABLE | RAW_TABLE]
select * from SCOTT.A_[LOB_TABLE | XMLTYPE_TABLE | USERDEFINEDTYPE _TABLE |
LONG_TABLE | RAW_TABLE]
;
Thanks,
Chris Marquez
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
