Re: data extract out of Oracle
From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Sat, 19 Feb 2000 05:10:13 GMT
Message-ID: <88l8jl$4hm$1_at_nnrp1.deja.com>
Following script (generated using SQLPlusPlus freeware) will create the text file from SQLPlus for EMP table. You can easily change delimiters/columns list etc.
| 3. Oracle CBT with sample GL Accounting System
| Download free: http://www.geocities.com/armaghan/
| SQLPlusPlus now on http://www.ioug.org/
| "PL/SQL package that extends SQL*Plus to another dimension.
| Contains a PL/SQL code generator and set of extremely useful
| utilites with extensive documentation." IOUG Web Site
Date: Sat, 19 Feb 2000 05:10:13 GMT
Message-ID: <88l8jl$4hm$1_at_nnrp1.deja.com>
Following script (generated using SQLPlusPlus freeware) will create the text file from SQLPlus for EMP table. You can easily change delimiters/columns list etc.
| SET HEADING OFF
| SET PAGESIZE 0
| SET TERMOUT OFF
| SET FEEDBACK OFF
| SET LINESIZE 2000
| SET TRIMSPOOL ON
| SPOOL test_dept.dat
| SELECT
| deptno||CHR(44)
| ||chr(34)||dname||chr(34)||CHR(44)
| ||chr(34)||loc||chr(34)||CHR(44)
| ||deptsal
| FROM test.dept;
| SPOOL OFF
|
| SET TERMOUT ON
regards,
M. Armaghan Saqib
+---------------------------------------------------------------| 2. SQL Link for XL => Integrate Oracle with XL
| 1. SQL PlusPlus => Add power to SQL Plus command line
| 3. Oracle CBT with sample GL Accounting System
| Download free: http://www.geocities.com/armaghan/
+---------------------------------------------------------------
| SQLPlusPlus now on http://www.ioug.org/
| "PL/SQL package that extends SQL*Plus to another dimension.
| Contains a PL/SQL code generator and set of extremely useful
| utilites with extensive documentation." IOUG Web Site
+---------------------------------------------------------------
Jonah Egenolf <jegenolf_at_kenan.com> wrote in message news:38ADA269.109A79AF_at_kenan.com...
> Is there a fast way to extract data out of Oracle into a text file, > preferably with user-defined column and row delimiters? > > Are there any utilities out there that do this?
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Feb 19 2000 - 06:10:13 CET