How to create a csv type output via a select statement

Dev Shed Forums Sponsor:

Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here!

January 8th, 2004, 04:10 PM

jgabay

Junior Member

Join Date: Jan 2004

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

How to create a csv type output via a select statement

I need to write a select statement where the results are listed in a comma separated format.

select table_name from user_tables;

I would the result to be listed in one long line with each table name separated by a comma.

Any ideas, suggestions?

JP

January 9th, 2004, 10:17 AM

Dan Drillich

Contributing User

Join Date: Sep 2003

Posts: 68

Time spent in forums: < 1 sec
Reputation Power: 5

Please try:

select table_name || ',' from user_tables;

Cheers,
Dan

January 9th, 2004, 10:19 AM

jgabay

Junior Member

Join Date: Jan 2004

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

Sorry but that will only put a comma after each table name.

February 28th, 2004, 05:23 AM

lt_jake

Registered User

Join Date: Feb 2004

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

DECLARE @Tables VARCHAR(5000)
SELECT @Tables = COALESCE(@Tables + ', ', '') + table_name
FROM user_tables
SELECT @Tables

Viewing: Dev Shed Forums > Databases > Oracle Development > How to create a csv type output via a select statement

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump