Oracle-L: RE: Oracle From a Sybase DBA perspective| What is a Database to S

From: Toepke, Kevin M <ktoepke_at_trilegiant.com>
Date: Mon, 01 Apr 2002 08:18:36 -0800
Message-ID: <F001.00437E00.20020401081836@fatcity.com>

Here is the URL for the PRO*C code to dump data from a query to a flat file.

http://asktom.oracle.com/pls/ask/f?p=4950:8:646297::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:459020243348,%7BSQLDA%7D -----Original Message-----
Sent: Monday, April 01, 2002 11:10 AM
To: Toepke, Kevin M; 'ORACLE-L_at_fatcity.com' S

whoopse. pasted the wrong URL. I'll send the correct one as soon as I can find it.

-----Original Message-----
Sent: Monday, April 01, 2002 11:00 AM
To: 'ORACLE-L_at_fatcity.com'
S

There is code for a basic "SQL Unloader" tool available at asktom.oracle.com. Completely dynamic. Limited support for LONGs and no support for LOBs or objects, but generally pretty good. Does bulk fetches.

http://osi.oracle.com/~tkyte/flat/index.html

-----Original Message-----
Sent: Monday, April 01, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L S

bcp out - It's time Oracle came up with some utility to extract the data in ascii format other than recommending "sqlplus and spool"

What about utl_file functions?

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Freeman, Robert
INET: Robert_Freeman_at_csx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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: Toepke, Kevin M
INET: ktoepke_at_trilegiant.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------