select data from oracle table and save the output as csv file

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
select data from oracle table and save the output as csv file

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
select data from oracle table and save the output as csv file or .txt file in unix/solaris - script	aemunathan	Shell Programming and Scripting	4	4 Weeks Ago 10:13 PM
how to extract the data from database (oracle) and send the output as an .xls file?	psiva_arul	Shell Programming and Scripting	1	10-13-2009 02:58 PM
load a data from text file into a oracle table	raji35	Shell Programming and Scripting	2	01-15-2009 03:48 AM
To load data from variable to oracle table ....???	Amit.Sagpariya	Shell Programming and Scripting	2	12-15-2008 08:36 AM
To load data from variable to oracle table	Amit.Sagpariya	Shell Programming and Scripting	1	12-15-2008 07:20 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#3 (permalink)

4 Weeks Ago

radoulov

addict

Join Date: Jan 2007

Location: Варна, България / Milano, Italia

Posts: 2,928

I think you need something like this:

Code:

select emp_name||'  ,'|| emp_add||'  ,'|| dest_name
  from ( 
    select 
      e.employee_name emp_name,
      e.employee_address emp_add,
      d.department_name dest_name
      ...

---------- Post updated at 09:35 AM ---------- Previous update was at 09:26 AM ----------

Quote:

Originally Posted by panyam

Better you can use the "set options" available with SQL*PLUS.

something like this :

Code:

set colsep=','

With colsep the result will depend on linesize and the output could be different from what you expect:

Code:

SQL> set lines 132
SQL> set colsep ,
SQL> select ename name, customerid id from t;

NAME      ,        ID
----------,----------
name1     ,         1
name2     ,         2

SQL> select name||', '||id from (select ename name, customerid id from t);

NAME||','||ID
----------------------------------------------------
name1, 1
name2, 2

SQL> set lines 10
SQL> select ename name, customerid id from t;

NAME
----------
        ID
----------
name1
         1

name2
         2


SQL> select name||', '||id from (select ename name, customerid id from t);

NAME||','|
----------
name1, 1
name2, 2

Bookmarks

Tags

alias, format, sql output

« Significance of '{}' \; | How to verify all user home directories are writable only by their owner »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode 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 BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 09:20 AM.