sql table to csv

SET FEEDBACK OFF 



SET HEAD ON 



SPOOL C:\Oracle\EXPORT_CUSTOMER.CSV 



SELECT ID||','||PWD||','||NAME||','||ZIPCODE||','||ADDRESS1||','||ADDRESS2||','||MOBILE_NO||','||PHONE_NO||','||CREDIT_LIMIT||','||EMAIL||','||ACCOUNT_MGR||','||BIRTH_DT||','||ENROLL_DT||','||GENDER FROM CUSTOMER; 



SPOOL OFF 





----------------------------- 

SET FEEDBACK OFF 



SET HEAD ON 



SPOOL C:\Oracle\EXPORT_CUSTOMER.CSV 



SELECT /*csv*/ * FROM CUSTOMER; 



SPOOL OFF