RE: Dbms_Utility.Table_To_Comma

From: <dieter.oberkofler_at_chello.at>
Date: Thu, 18 Jan 2001 22:41:20 +0100
Message-Id: <10745.127083@fatcity.com>

Hi Santhosh!

The procedure you are referring to will probably not do what you expected it to do. It is used to convert comma separated values in a string to a table of strings and vice versa. It is basically a tokenizer.

You might want to have a look a my shareware tool TabExp that allows you to export any oracle table to several file formats like CSV, HTML, XML or a list SQL commands. Download it from my web page at http://www.materialdreams.com/products.html and check it out.

Cheers

DO

email: info_at_materialdreams.com
web: www.materialdreams.com

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Channa, Santhosh, SITS
Sent: Thursday, January 18, 2001 10:08 PM To: Multiple recipients of list ORACLE-L Subject: Dbms_Utility.Table_To_Comma

Listers,

I've seen somebody talking about DBMS_UTILITY.TABLE_TO_COMMA package to extract table data into a text file. I am trying to use this package and some how am not able to get it work correct. If there is somebody using this utility, could you please tell me the syntax for this?

Santhosh Channa

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Channa, Santhosh, SITS
  INET: schanna_at_att.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 18 2001 - 15:41:20 CST