Re: Dump Ascii File From Oracle 6

From: DavidJRoth <davidjroth_at_aol.com>
Date: 2 Dec 1994 18:35:34 -0500
Message-ID: <3bob06$jc2_at_newsbf01.news.aol.com>


In article <3bldm4$agq_at_nntp.crl.com>, jeffg_at_elpaso.cartotech.com (Jeff Gerth) writes:

select '1','select' from dual
union
select '2',column_name||',' from user_tab_columns where table_name=??? union
select '3','from ???;' from dual
order by 1;

This script will produce another script that can be used to dump ASCII delimited
data. Note that the new script will still need some editing but it should be close. Received on Sat Dec 03 1994 - 00:35:34 CET

Original text of this message