Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


INSERT INTO SELECT with subquery


Can I do something like this??  INSERT  INTO  tbl1 SELECT A,B,C,D,ID,(SELECT KEY FROM TBL2 WHERE X=ID),E,F FROM TBL3;  Can I use same column ID in 2 places as above?

929954 wrote: Can I do something like this??  I give up. Can you?    INSERT  INTO  tbl1 SELECT A,B,C,D,ID,(SELECT KEY FROM TBL2 WHERE X=ID),E,F FROM TBL3;  Can I use same column ID in 2 places as above?  What happens when you did it?  Handle:	 929954   Status Level:	 Newbie Registered:	 Apr 24, 2012 Total Posts:	 9 Total Questions:	 3 (3 unresolved)  REALLY? 0 for 3?  Edited by: sb92075 on May 4, 2012 6:53 PM

the script ran forever...

929954 wrote: the script ran forever...  post EXPLAIN PLAN

Is it not the same as INSERT INTO tbl1 SELECT TBL3.A,TBL3.B,TBL3.C,TBL3.D,TBL3.ID, TBL2.KEY,TBL3.E,TBL3.F  FROM TBL3, TBL2 WHERE TBL3.ID=TBL2.X   Hemant K Chitale


Related Links

Configuration of standby database
configuring 9i database for the first time (92010nt_clt.zip) on win 98 se
Indexes
hi
update hangs - 10g 10.2.0.2.0
importing a dump fails on Oracle 11g
hi all
Oracle Data Guard with large geographical datasets.
HWM
shared pool on 8i (win box)
Builtin Tablespace monitoring not working.
Measuring data loss in Data Guard 10g
Data Guard
finding how many rows in a table
Info needed on X_$ or V_$ !!
DB Switch from Noarchive to Archive