OraFAQ Forum: SQL & PL/SQL » A Way to pass an Oracle Table into Text File

Home » SQL & PL/SQL » SQL & PL/SQL » A Way to pass an Oracle Table into Text File

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

A Way to pass an Oracle Table into Text File [message #20369]

Sat, 18 May 2002 07:50

Sulaiman Gboyega N.
Messages: 17
Registered: April 2002

Junior Member

Hi All,

Does anybody know of a quick way to export an Oracle table into text file?

I know export utility creates a binary file, but I want is a text file.

Any help will be appreciated.

Thanks.

Report message to a moderator

Re: A Way to pass an Oracle Table into Text File [message #20375 is a reply to message #20369]

Sun, 19 May 2002 10:45

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

If you want to write it yourself, either use the UTL_FILE package to generate the text file on the server or use SQL*Plus to spool the output on the client side.

There are also many utilities available to handle this for you including TOAD (a free version is available at www.toadsoft.com).

Report message to a moderator

Previous Topic:	working with triggers, error substitute number for '.'
Next Topic:	Practice software - HELP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 06:19:21 CDT 2024