Solved

Generating tab delimited report

Posted on 2000-04-02
2
1,764 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

734 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