SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET LINESIZE 10000
SET NUMWIDTH 20
SET PAGESIZE 0
SET TERMOUT OFF
SET TRIMSPOOL ON
SPOOL D:\ILSAPPL\DataCloset\WORK\SUPER\TBLINFO.TXT

SELECT
'"' || COLUMN_NAME || '",' ||
'"' || DATA_TYPE || '",' ||
'"' || DATA_LENGTH || '",' ||
'"' || DATA_PRECISION || '",' ||
'"' || DATA_SCALE || '",' ||
'"' || COLUMN_ID || '"'
FROM SYS.USER_TAB_COLUMNS
WHERE TABLE_NAME='IKO_MITSUMORI'
;

SPOOL OFF
SET ECHO ON
SET FEEDBACK ON
SET HEADING ON
SET LINESIZE 80
SET NUMWIDTH 10
SET PAGESIZE 24
SET TERMOUT ON
SET TRIMSPOOL OFF

EXIT
