Cool!
-----Original Message-----
From: António Pedro Lemos dos Santos [mailto:oracledba-ezmlmshield-x59658484.[Email address protected]
Sent: Monday, February 28, 2005 10:16 AM
To: LazyDBA Discussion
Subject: Re: Need Solution
Much faster:
INSERT INTO y(e,f,g)
SELECT a,b,c
FROM x,y
WHERE x.a=y.e (+) AND y.e IS NULL
António Pedro Santos
Estradas de Portugal, EPE
----- Original Message -----
From: Yao Chris
To: LazyDBA Discussion
Sent: Monday, February 28, 2005 3:06 PM
Subject: RE: Need Solution
Not so sure what you try to do. Just give it a try -
INSERT INTO y (e, f, g)
SELECT a, b, c
FROM x
WHERE a NOT IN (SELECT e FROM y)
Chris Y.
-----Original Message-----
From: Rekha Kadam
[mailto:oracledba-ezmlmshield-x87945665.[Email address protected]
Sent: Monday, February 28, 2005 7:07 AM
To: LazyDBA Discussion
Subject: Need Solution
Hi ,
I have one table x with a,b,c column.
and second table y with column e,f,g
I have to insert record into Table y , in which column 'e' has to be
maintain unique without applying any Trigger, Constraint, Sequence ,
PL/SQL.,
column 'f' will insert from table x column b.
Plz give me solution for this.
With Regards,
Rekha.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page