×
Discuss on any other topics
How to export Table from Oracle to CSV file.
- kampoul
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 20
- Thank you received: 0
12 years 7 months ago #11250
by kampoul
How to export Table from Oracle to CSV file. was created by kampoul
Hi All!
Could you all tell me how to export Table from Oracle to CSV file,Please? Cos I need to export file F.PROTOCOL.
Thanks in advance.
Could you all tell me how to export Table from Oracle to CSV file,Please? Cos I need to export file F.PROTOCOL.
Thanks in advance.
Please Log in or Create an account to join the conversation.
- durai611
- Offline
- Elite Member
-
Less
More
- Posts: 300
- Thank you received: 51
12 years 7 months ago #11252
by durai611
Replied by durai611 on topic Re: How to export Table from Oracle to CSV file.
Hi kampoul,
Check these links
tkyte.blogspot.com/2009/10/httpasktomoraclecomtkyteflat.html
www.oracle-base.com/articles/9i/generating-csv-files.php
If you search in web you can get more.
But what I doubt is, how it's going to store data in the file? Since the data are stored as XML type in Oracle.
Check these links
tkyte.blogspot.com/2009/10/httpasktomoraclecomtkyteflat.html
www.oracle-base.com/articles/9i/generating-csv-files.php
If you search in web you can get more.
But what I doubt is, how it's going to store data in the file? Since the data are stored as XML type in Oracle.
The following user(s) said Thank You: kampoul
Please Log in or Create an account to join the conversation.
- wam
- Offline
- Senior Member
-
Less
More
- Posts: 55
- Thank you received: 3
12 years 7 months ago #11256
by wam
Replied by wam on topic Re: How to export Table from Oracle to CSV file.
You can just extract it either by some routine/tool and then export it into a .CSF file
OR
can use SAVING EVAL fucntion on jshell to get the list and then saving it into your required format.
OR
can use SAVING EVAL fucntion on jshell to get the list and then saving it into your required format.
Please Log in or Create an account to join the conversation.
- Valleyman1
- Visitor
-
12 years 4 months ago #11922
by Valleyman1
Replied by Valleyman1 on topic Re: How to export Table from Oracle to CSV file.
hi
like most sql you can select the whole table into a text file.open the test file with excel or any spreadsheet program. Save the file as csv.
like most sql you can select the whole table into a text file.open the test file with excel or any spreadsheet program. Save the file as csv.
Please Log in or Create an account to join the conversation.
- shanthi
- Offline
- Premium Member
-
Less
More
- Posts: 128
- Thank you received: 10
12 years 3 months ago #12245
by shanthi
Replied by shanthi on topic How to export Table from Oracle to CSV file.
Let me know if you are still looking for a solution in this regards.
Please Log in or Create an account to join the conversation.
Time to create page: 0.084 seconds