Re: Need a SQL*UNLoader

From: Richard W. Harris <rwh4+_at_pitt.edu>
Date: Mon, 12 Dec 1994 15:44:06
Message-ID: <rwh4+.160.000FBCA0_at_pitt.edu>


In article <3chrgs$cc5_at_killerbee.jsc.nasa.gov> sspruell_at_ssf3.jsc.nasa.gov (Steven Spruell) writes:
>From: sspruell_at_ssf3.jsc.nasa.gov (Steven Spruell)
>Subject: Need a SQL*UNLoader
>Date: 12 Dec 1994 15:50:52 GMT
 

>Has anyone got any info on products or techniques to generate a delimited
>export file from Oracle tables? I know I can use sqlplus or Reports and
>generate a seperate report for each table, but I was looking for something
>a little more generic. I guess Oracle is under the impression that no one
>would ever want to EXPORT data FROM Oracle, sort of like once you've reached
>nirvana, why would you want to go back?

I've never actually tried this (I guess I'm in nirvana :-), but,

  1. Go into SQLPLUS.
  2. set echo off
  3. set heading off
  4. set termout off
  5. set feedback off
  6. spool <output file name>
  7. select <field 1>||','||<field 2>||','||<field 3> (etc) from (etc);
  8. spool off
  9. exit

Let me know how it works out.

>Thanks in advance,
>Steven Spruell
>sspruell_at_ssf3.jsc.nasa.gov

  • Rick

Richard Harris, Systems Analyst (rwh4+_at_pitt.edu) Office Systems Services, University of Pittsburgh

"Long as you're not afraid, nobody can run your life  for you. Remember that. Hell is being scared of things.  Heaven is refusing to be scared. I mean that literally."

  • Boomer, "Skinney Legs and All" by Tom Robbins
Received on Mon Dec 12 1994 - 15:44:06 CET

Original text of this message