formatting the output of a sql query.

Question

Hi! I am using solaris os. from solaris im logging into sql plus. my database is oracle 9i. i am spooling the output of my query into a file. i want in .csv format so that i can copy it into excel. can any1 help me out. my query is like. select name,id,location from employee;

Answer 1

hi! i have found a way out of it. we can use concatenation here. select name,id,location from employee; gives us 2 different columns, but not in a csv format. what i did is

select name||','||id||','||location from employee; we get the output in a csv format. it has just concatenated the output with commas(,).