Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle SQL Condition Question...

Re: Oracle SQL Condition Question...

From: Julio <julio.negueruela_at_si.unirioja.es>
Date: 1998/04/23
Message-ID: <353F555B.2E85E99B@si.unirioja.es>#1/1

Ajay Kulkarni escribi :
>
 

> To improve the processing time use the following query
>
 

> insert into tab3
> select f1 from tab1
> minus
> select f2 from tab2

I'm afraid that Bhavesh wants to insert all columns of tab1, not only f1.  

Anyway, you haven't told us if you've got any index in tab3. If so you should drop them and re-create them after the insert operation.

Regards.

-- 

Julio Negueruela
DBA    Servicio Inform tico
Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180
mailto:julio.negueruela_at_si.unirioja.es
Received on Thu Apr 23 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US