Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Unload data from table to file
Name: Nuthan Prasad Date: June 12, 2008 at 23:28:48 Pacific OS: HP UNIX CPU/Ram: 1 GB
Comment:
Hi, Is it possible to download the contents of a table into a flatfile from Oracle DB, without headings and with delimiters lmiting the column values. Ex: the file contents should be like column1|column2|column3|column4
Is there any other option other than spool to achieve this. In informix we have the command unload to <fileL delimieter "|" select * from <table>
Name: doodzl Date: September 15, 2008 at 04:51:26 Pacific
Reply:
in mysql there is a tool which will do it, it isnt a built-in function, i am guessing the same for Oracle but try looking on google for oracle dump software.
Summary: Hi, Maybe someone can give me advice , I am relatively new to Oracle and I need to load data from a text file into a database table. The format of the file and DB table is below so I would need an ...
Summary: i am currently working on my project. its home automation. and im using a free web server to store my data. what i want to know is how to transfer my data from the database to my pc for execution of t...
Summary: Create an RMA table with the following fields (add additional fields as needed) rma_id customer_id rma_description rma_date ... The user_id field in the RMA table should be the same customer_id in the...
0 
