SQL>create table test (id number(2), first_name varchar2(15), last_name varchar2(15),var_no number(4),
type varchar2(1),type_no number(12));

Table created.

SQL> insert into test values(1,'mary','ross',132,'S',12);

1 row created.

SQL> insert into test values(3,'Sue','Bill',432,'S',12);

1 row created.

set echo off
set feedback off
set linesize 1000
set pagesize 4000
set trim on 
set headsep off
set colsep '' (used tab between the quote)

spool test.csv
select id,first_name,last_name,var_no,type,type_no from test;
spool off

SQL> host type x.sql
set colsep '    '
set recsep off
set head on
set headsep off
set trimspool on
set feedback off
set linesize 1000
col type format a4
spool x
select id, '"'||first_name||'"' first_name, '"'||last_name||'"' last_name, var_no,
       '"'||type||'"' type, type_no
from test
/
spool off

SQL> @x
        ID      FIRST_NAME              LAST_NAME                   VAR_NO      TYPE       TYPE_NO
----------      -----------------       -----------------       ----------      ----    ----------
         1      "mary"                  "ross"                         132      "S"             12
         3      "Sue"                   "Bill"                         432      "S"             12
SQL> host type x.lst
        ID      FIRST_NAME              LAST_NAME                   VAR_NO      TYPE       TYPE_NO
----------      -----------------       -----------------       ----------      ----    ----------
         1      "mary"                  "ross"                         132      "S"             12
         3      "Sue"                   "Bill"                         432      "S"             12

SQL> select dbms_assert.enquote_literal(owner) owner, dbms_assert.enquote_name(table_name) table_name
  2  from all_tables
  3  where owner = USER
  4* order by 1;
 
OWNER                          TABLE_NAME
------------------------------ ------------------------------
'UWCLASS'                      "AIRPLANES"
'UWCLASS'                      "MV_FGA"
'UWCLASS'                      "SERV_INST"
'UWCLASS'                      "POSTAL_CODE"
'UWCLASS'                      "DBA_OBJECTS2"
'UWCLASS'                      "CALTAB"
'UWCLASS'                      "T"
'UWCLASS'                      "DEPARTMENT"
'UWCLASS'                      "NO_COMPRESS"
'UWCLASS'                      "OLTP_COMPRESS"
'UWCLASS'                      "OLTP_COMPRESS_DIRECT"
'UWCLASS'                      "MLOG$_FGA_DEMO"
'UWCLASS'                      "FGA_DEMO"
'UWCLASS'                      "PLSQL_PROFILER_RUNS"
'UWCLASS'                      "PLSQL_PROFILER_UNITS"
'UWCLASS'                      "PLSQL_PROFILER_DATA"
'UWCLASS'                      "RUPD$_FGA_DEMO"
'UWCLASS'                      "SERVERS"