Hi Gurus<br><br>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? <br><br>Quick response is appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Tab delimited Output from Oracle 8i
- Thread starter sethu
- Start date
You can do it with sql/plus and a bit of sed/perl/depends on your platform wizardry.<br><br>Have a look for "flat file" in the sql/plus help - there're instructions <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href= Cargill's Corporate Web Site</a><br>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?"
- Status
Similar threads
- Locked
- Question