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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Aug 2006 08:15:49 -0700
Message-ID: <1154531749.112560.44130@i3g2000cwc.googlegroups.com>

Martin T. wrote:
> 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

Martin, flat files created using External Tables in 10g are usable only via datapump, per the documentation, and as such will probably will not meet the OP's needs.

It is extremely easly to extract flat files from Oracle using queries and the spool file feature of SQL*Plus and/or the utl_file package. Pro*C is always an option.

HTH -- Mark D Powell -- Received on Wed Aug 02 2006 - 10:15:49 CDT