You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
10 lines
822 B
SQL
10 lines
822 B
SQL
SET FEEDBACK OFF
|
|
SET PAGESIZE 0
|
|
SET LINESIZE 300
|
|
SET LONG 90000000
|
|
SET ECHO OFF
|
|
SET HEAD ON
|
|
SPOOL /app/tcs/GREEN_LANE/jar/make_empt/EXEMPT_CARS_INFO.CSV
|
|
select to_char(ENFORCE_DATE, 'YYYYMMDDHH24MISS')||','||CAR_NO||','||CARS_TYPE_ID||','||FILE_KIND_ID||','||DATA_SEQNO||','||YEAR||','||MONTH||','||DAY||','||DOCUMENT_NO||','||CAR_TYPE_NAME||','||OWNER||','||to_char(END_DATE, 'YYYYMMDDHH24MISS')||','||to_char(DOCUMENT_DATE, 'YYYYMMDDHH24MISS')||','|| POSITION_BODY||','|| to_char(ACCEPT_DATE, 'YYYYMMDDHH24MISS')||','||REPLACE_KBN||','||REPLACE_CAR_NO||','|| END_KBN||','|| REMARKS||','|| TRANS_FILE_CREATE_YN||','|| to_char(CREATE_DATE, 'YYYYMMDDHH24MISS')||','||CREATER||','|| to_char(UPDATE_DATE, 'YYYYMMDDHH24MISS')||','||UPDATER||','||EXEMPT_KBN||','||COMPANY_KBN||','||USE_REMARK FROM EXEMPT_CARS_INFO;
|
|
SPOOL OFF
|