Your select statement does no corespond to your result.
I think that there is an missingrow in select.

However - try with:

select column_id||chr(9)||data_type||chr(9)||column_name
from user_tab_columns
where table_name = 'COMPONENT'
order by column_id;

or:

select column_id,data_type,column_name
from user_tab_columns
where table_name = 'COMPONENT'
order by column_id;

KAzi

sivagurunathan wrote:

>Hi,
>
>I have a query like the one below.
>
>Spool c:\ee.txt
>
>Prompt select
>
>select column_name ||'||chr(9)||'
>
>from user_tab_columns where table_name = 'COMPONENT' order by column_id;
>
>
>Prompt component;;
>
>Spool off
>
>The out put will be like this in the text file.
>
>SELECT
>
>ID||chr(9)|| TYPE||chr(9)|| NAME||chr(9)||
>
>
>FROM COMPONENT;
>
>I want the output like the one below
>
>SELECT
>
>ID||chr(9)|| TYPE||chr(9)|| NAME
>
>
>FROM COMPONENT;
>
>How to remove ||chr(9)|| from the last column? Please help me
>
>Thanks and Regards,
>
>Siva
>
>
>
>
>
>Confidentiality Notice
>
>
>The information contained in this electronic message and any attachments to this message are intended
>for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
>you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
>and destroy all copies of this message and any attachments.
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>


Oracle LazyDBA home page