Re: DTS equivalent for Oracle

On Oct 27, 7:33 am, "gazzag" <gar..._at_jamms.org> wrote:
> Gerge wrote:
> > I have code (scripts) that perform manipulation on data and output to
> > text or excel. I'm looking to replace this with a package similar to
> > DTS in MSSQL. Does something like this exist as part of the Oracle
> > package ?What version of Oracle?
>
> What operating system?
>
> What exactly are you trying to achieve? Not everyone knows DTS :)
>
> -g

See the PL/SQL guide and look up utl_file in the PL/SQL Supplied Packages and Types Guide. Manual name slightly different depending on Oracle documentation version.

You can create delimited files via SQLPlus and open those with Excel.

Someone wrote a Perl module that will take Oracle data and convert it into Excel internal format.

Lots of potential options depending on exactly what you want to do.

HTH -- Mark D Powell -- Received on Fri Oct 27 2006 - 20:48:37 CEST