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

riteshjain82_at_gmail.com wrote:
> Yeah but the thing is that we are not allowed to use any of these tools
> or utilities.

Is this a homework assignment?

 > 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??

You can use SQL*Plus to create CSV files. SQL*Plus has a lot nice features for formatting etc.

        robert Received on Wed Aug 02 2006 - 10:06:20 CDT