| how to convert oracle table data into text file [message #62912] |
Tue, 24 August 2004 03:29  |
t dharmaraj
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
i have one requirement of converting the oracle table data into plain text file.Is it possible.
I know the the reverse process that is from text file to table data through the oracle utility sqlldr.
but i want to know the utility for converting table data into text file.
My Oracle version 8i. on AIX platform.
such as MsAcess allows us to convert the access file into text file, or excel file etc.
|
|
|
|
|
|
|
|
| Re: how to convert oracle table data into text file [message #62954 is a reply to message #62912] |
Fri, 27 August 2004 21:11  |
Balaji
Messages: 102
Registered: October 2000
|
Senior Member |
|
|
hi dharmaraj ,
you have an other way too .
1.Take a windows machine and configure the ODBC to the database you have the tables in .now this machine must have the msaccess too.
2.every time you need a table from oracle into access just go to iport in the file menu and select the ODBC file format and get the tables created,data inserted into this access database.
3.Access gives you a lot of freedom to juggle with the data like you can create .csv file or enclose the values in quotes whether with a valid data or a null or change the data format .this way you can start juggling data .
ofcourse like our other friends said you can use the select col1||col2.... but take care to see the null cols .
with best wishes .
balaji
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
