Re: Whats the bcp (SQL Server) substitute in Oracle??

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 2 Aug 2006 07:38:33 -0700
Message-ID: <1154529513.573052.12290@i42g2000cwa.googlegroups.com>

riteshjain82_at_gmail.com wrote:
> Robert Klemme wrote:
> > riteshjain82_at_gmail.com wrote:
> (snip)
> Yeah but the thing is that we are not allowed to use any of these tools
> or utilities. We have to write a procedure for this.
> Also, i think that SQL Loader can only be used to load data in tables
> from flat files, while i need to create flat files from tables. Please
> correct me if i am wrong??

In 10g you can use the external table feature to unload data from the database to a file.
Maybe this would be an option for you here.

best,
Martin Received on Wed Aug 02 2006 - 09:38:33 CDT