RE: Way of extracting record

Right, you are!

• Kirti

-----Original Message-----
Sent: Tuesday, October 01, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L

This is in 8.1.x and higher, not 8.0.x, right? Ruth

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 01, 2002 3:39 PM

> Here is how:
>
> exp scott/tiger tables=emp query=\"where job=\'SALESMAN\' and sal\<1600\"
>
> When executing this command, Export builds a SQL SELECT statement similar
to
> this:
> SELECT * FROM EMP where job='SALESMAN' and sal <1600;
>
> (From Utilities Guide)
>
>
> - Kirti
>
> -----Original Message-----
> Sent: Tuesday, October 01, 2002 10:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> > 3. You can use export with QUERY option to export just the
> > rows you need from each table in Production and import those
> > into Development database. However, it will depend on how
> > easy it is to get to the required data by the QUERY option
> > (available with Oracle 8i).
>
>
> Can you elaborate how the querry option is done? The only individualized
> method of exporting (using exp)
> I'm familiar with is with
>
> Tables=
>
> thanks
> bob
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bob Metelsky
> INET: bmetelsky_at_cps92.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).