Re: newbie dumping tables and columns to text file

From: George Lewycky <gelewyc_at_nyct.com>
Date: 10 Feb 2007 11:34:58 -0800
Message-ID: <1171136098.473726.200330@q2g2000cwa.googlegroups.com>

SQL+ has "COLSEP" you can pick a delimiter and just code the SQL like it where a regular
query

i have an example at http://georgenet.net/oracle

george

On Feb 9, 3:39 am, seannakas..._at_yahoo.com wrote:
> Hello, I'm a newbie to sql and oracle. I'm using sqlplus on windows
> (probably doesn't matter what platform) and want to dump out all the
> user tables and columns to a text file. I would like the format to be
> as follows:
>
> MyTable1 > MyColumn1
> MyTable1 > MyColumn2
> ...
> MyTable2 > MyColumn1
> MyTable2 > MyColumn2
> ...
>
> Is there an sql script that can do this?
>
> thanks,
> Sean.
Received on Sat Feb 10 2007 - 13:34:58 CST