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 -----..
2021. 7. 2.