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.

| 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

+---------------------------------------------------------------


| 1. SQL PlusPlus => Add power to SQL Plus command line

| 2. SQL Link for XL => Integrate Oracle with XL
| 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