Re: Export table into flat text files

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Tue, 22 Feb 2000 03:00:30 GMT
Message-ID: <88su4d$45a$1@nnrp1.deja.com>

Using my SQL PlusPlus (freeware) I could generate an SQL Plus script which will do the job.

SQL> exec s.h('blddat')
| ----------------------------------------------------------------------

---

| BLDDAT -- Build ASCII Flat Files from Tables
| ----------------------------------------------------------------------

---

| PROCEDURE s2.blddat (tabname IN VARCHAR2 DEFAULT '%',
| own IN VARCHAR2 DEFAULT USER);
|
| ----------------------------------------------------------------------

---

SQL> exec s2.blddat('dept')
| 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

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

Jun Garcia <jgarcia_at_junpg.net> wrote in message news:38B0DFCF.8ADFC8B_at_junpg.net...
> Hello. We're kind of knew to Oracle and we need to export all the tables
> in our database into flat text files. Can anyone please guide us on how
> to do this? Thanks.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 21 2000 - 21:00:30 CST