Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
How to create ASCII file in oracle with out using UTL package
This is a discussion on How to create ASCII file in oracle with out using UTL package within the Oracle forums, part of the Databases category; Hi All, I have been given task of creating an ASCII file with out using UTL package. I need to dump data from one of the oracle table and dump ...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
01-29-2008
|
|||
|
|||
How to create ASCII file in oracle with out using UTL package
Hi All,
I have been given task of creating an ASCII file with out using UTL package. I need to dump data from one of the oracle table and dump the same in the ASCII file. Any help on the above is much appreciated. Regards, Srini. 
|
| Sponsored Links |
|
02-04-2008
|
|||
|
|||
|
Re: How to create ASCII file in oracle with out using UTL package
Try to use the Export utility.
|
| The Following User Says Thank You to debasisdas For This Useful Post: | ||
|
02-05-2008
|
|||
|
|||
|
Re: How to create ASCII file in oracle with out using UTL package
Quote:
u can use this also set pagesize 0 set pause off set heading off spool ASCIIFILE select ename||','||eno||','||hiredate||','||sal from emp; spool off
|
| The Following User Says Thank You to susarlasireesha For This Useful Post: | ||
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Package oracle.jdbc.driver does not exist | Geek_Guest | Oracle | 4 | 03-30-2009 08:46 AM |
| Oracle Package.function | Yajnas | Oracle | 5 | 01-12-2009 02:16 AM |
| I am not able to get output after I create package | Geek_Guest | Java | 2 | 10-24-2007 12:58 AM |
| Today's package includes both StarPort Professional which will allow you to create vi | JobHelper | Geeks Lounge | 0 | 02-19-2007 07:40 AM |
| Oracle package question | always_rgsm | Oracle | 5 | 01-23-2007 08:35 AM |
All times are GMT -4. The time now is 12:08 AM.
