19,612
社区成员
发帖
与我相关
我的任务
分享
echo "(" >>$FULL_FILENAMECTL
sqlplus -S $ORA_USER/$ORA_PASSWD@$ORA_SID <<EOF >>$FULL_FILENAMECTL
set trimspool on
set feedback off
set linesize 9999
set pagesize 0
set heading off
set termout off
SELECT CASE WHEN F1.DATA_TYPE LIKE '%CHAR%' THEN F1.COLUMN_NAME||' CHAR('||F1.DATA_LENGTH||')' ELSE F1.COLUMN_NAME END||CASE WHEN F1.COLUMN_ID !=F2.COLUMN_NUM THEN ',' ELSE '' END FROM USER_TAB_COLUMNS F1 INNER JOIN (SELECT COUNT(1) AS COLUMN_NUM FROM USER_TAB_COLUMNS T1 WHERE T1.TABLE_NAME = '$TABLENAME') F2 ON 1=1 WHERE F1.TABLE_NAME = '$TABLENAME' ORDER BY F1.COLUMN_ID;
EOF
echo ")" >> $FULL_FILENAMECTL