Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Tab delimited Output from Oracle 8i

Tab delimited Output from Oracle 8i

Tab delimited Output from Oracle 8i

Hi Gurus

I want to automatically run a report on daily basis against an Oracle8i database (on Solaris 2.7)table which will write an output to a text file in tab delimited format. Should I have to use any particular software to do that, like Crystal Reports or can I use Sql*Plus to do that? If so how?

Quick response is appreciated.

RE: Tab delimited Output from Oracle 8i

You can do it with sql/plus and a bit of sed/perl/depends on your platform wizardry.

Have a look for "flat file" in the sql/plus help - there're instructions

Cargill's Corporate Web Site
Please -- Don't send me email questions without posting them in Tek-Tips as well. Better yet -- Post the question in Tek-Tips and send me a note saying "Have a look at so-and-so in the thingy forum would you?"

RE: Tab delimited Output from Oracle 8i

spool file
Select  chr(39) ¦¦ fieldname ¦¦ chr(39) ¦¦ chr(44) ¦¦ chr(39) ¦¦ fieldname ¦¦ chr(39) ¦¦ chr(10)
 ¦¦ ';'
from owner.tablename;
spool off

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close