By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,909 Members | 2,016 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,909 IT Pros & Developers. It's quick & easy.

Comma-delimited File PL/SQL

P: 10
Hi,

How do I write a function in SQL to convert data from a table to a comma delimited text file and get it imported in excel or word? I already have a function that convers data to an xml. but I need two other procedures one being the comma delimited file and another Fix Record Length File. HELP!
Feb 14 '07 #1
Share this Question
Share on Google+
5 Replies


ronverdonk
Expert 2.5K+
P: 4,258
See the following thread about the same question with reply/solution at http://www.thescripts.com/forum/thread601431.html

Ronald :cool:
Feb 14 '07 #2

P: 10
yeah but that code is using pear spread sheet. I need to specifically stick with PL/SQL. I know that CSV(COMMA SEPERATED VALUE) requires some cursors to loop the table and add a character to concatenate each one. I just dont know how to write the code. I am new to PL/SQL.
Feb 14 '07 #3

ronverdonk
Expert 2.5K+
P: 4,258
So you have stated that you must use PL/SQL in your starting post.
When you are using PL/SQL you are probably writing for Oracle DBMS. So what is your thread doing in the MySQL forum?

Ronald :cool:
Feb 14 '07 #4

P: 10
I couldnt find a forum for PL/SQL, I just assumed that it didnt matter I thought I would get help here too.
Feb 14 '07 #5

ronverdonk
Expert 2.5K+
P: 4,258
No, but there is a forum for Oracle. I will transfer this thread to there.

moderator
Feb 14 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.