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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Way of extracting record

RE: Way of extracting record

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Tue, 01 Oct 2002 13:43:40 -0800
Message-ID: <F001.004DDDF1.20021001134340@fatcity.com>


I see this now at the docs...

Bob Metelsky Client Services Development Phone 203-245-5089 ext 113 Fax 203-245-5001 Office 203-245-5000 Continuum Performance Systems Inc. http://continuumperformance.com/ PGP Public Key http://continuumperformance.com/cps.gpg

> -----Original Message-----
> From: Deshpande, Kirti [mailto:kirti.deshpande_at_verizon.com]
> Sent: Tuesday, October 01, 2002 5:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Way of extracting record
>
>
> Rafiq,
> Thanks.
> Absolutely, using par file has many such advantages (hiding
> username/password being one important other ;)
>
> - Kirti
>
>
> -----Original Message-----
> Sent: Tuesday, October 01, 2002 3:03 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Kirti,
>
> You are always helpful. Just to add further...
>
> It is more easier to use export.par file where you can put
> query clause very
>
> easily ie without back slashes like
>
> query=" where invdate between '29-DEC-97' and '03-JAN-99'"
>
> HTH,
>
> Regards
> Rafiq
>
> Note: Bob, this is for 8i and up....
>
> Reply-To: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: Tue, 01 Oct 2002 11:39:11 -0800
>
> 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).
>
>
>
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohammad Rafiq
> INET: rafiq9857_at_hotmail.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: 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).
Received on Tue Oct 01 2002 - 16:43:40 CDT

Original text of this message

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