Hi All, Here is the summary of all the mails I have recieved to Convert an oracle table into ASCII/Comma delimeted file. 1. Using sqlplus Set head off set pages 1000 spool result.lis Select col1 ||','|| col2 ||','|| col3 from table; spool off or 2. Set colsep , spool result.lis set head off set pages 1000 select * from table; spool off 3. Using Jump.sql from jared site http://www.cybcon.com/~jkstill/util/util_master.html This is a very good utility. 4. Toad also can be used for this Purpose. download from www.toadsoft.com 5. Tabexp is a very good utility that can be downloaded from www.materialdreams.com/product.html Thanks to all who has replied for my qyery. regds deepender
---------------------------------------------------------------------------------------------------------------------- Information transmitted by this E-MAIL is proprietary to Wipro and/or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailto:[EMAIL PROTECTED] and delete this mail from your records. ----------------------------------------------------------------------------------------------------------------------
