Solved

Generating tab delimited report

Posted on 2000-04-02
2
1,743 Views
Last Modified: 2012-08-14
I am trying to genearate a tab delimited report, using chr(9) between the select columns. select col1,chr(9),col2,chr(9)....

When I spool the output into a file the header does not get tab delimited. So the actual data appears to be moving away from the header. Is there a way to make the header tab delimted or is there an another way to achieve the same thing, so that I can get the both the header and the data starting at the same position. Please let me know if any one of you have got any ideas.

Thanks,
Subin
0
Comment
Question by:subingeorge
2 Comments
 
LVL 4

Accepted Solution

by:
sganta earned 100 total points
ID: 2678729
Hi,

You don't have to select the CHR(9) function in your select clause
for TAB delimited. you can do the following settings at the SQL prompt
or in your SQL file.

SET COLSEP '<PRESS TAB KEY>'

i.e

SET COLSEP '      '

Now you can select whatever you want from SQL, it will be delimited by
TAB.

Hope this helps you !
0
 

Author Comment

by:subingeorge
ID: 2681201
Your answer to my question is correct. But this does not work on SQL PLUS for NT or 98. For some reason SQL PLUS does not seems to identify the <TAB> key. It works fine with SQL PLUS through command prompt and also on UNIX. It also works with notedpad and vi editor. Thanks for the help!!!.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now