Solved

Generating tab delimited report

Posted on 2000-04-02
2
1,752 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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
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…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to recover a database from a user managed backup

813 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

14 Experts available now in Live!

Get 1:1 Help Now