Formatting sql in UNIX

hi folks
am running the shell script below

#!/bin/bash
sqlplus 'scott@orcl/tiger'<<ENDSQL >> outputlogfile.csv
SET PAGES 0
SET HEAD ON
SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 100
SET PAGESIZE 100
SET SERVEROUTPUT ON

--# Fire the query on database

select *
from employee;

ENDSQL

here am not getting the proper format in csv.

like column wise data but am getting all data in single cell only.

I want proper data to get please help me

Try

set colsep ";"

I think it should be comma instead of semicolon since requestor want data in CSV, so use:-

set colsep ,

By the way semicolon will also help if you use Text to Columns feature in Microsoft Excel using a delimiter (in this case semicolon).