OracleÊý¾Ý×ÖµäµÄµ¼³ö

-- ²éѯij±íµÄÊý¾Ý×Öµä
 SELECT  A.TABLE_NAME AS "±íÃû",A.COLUMN_NAME AS "×Ö¶ÎÃû",
 DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
 A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "×Ö¶ÎÀàÐÍ1",A.DATA_TYPE AS "×Ö¶ÎÀàÐÍ",A.DATA_PRECISION AS "ÓÐЧλ",A.DATA_SCALE AS "¾«¶ÈÖµ",
A.CHAR_LENGTH AS "×ֶ㤶È",A.NULLABLE AS "ÄÜ·ñΪ¿Õ"
 from sys.user_tab_columns A where A.table_name = 'TAM_ADDRESS'
 
--  ¾ßÓÐdbaȨÏÞÓû§µ¼³öÊý¾Ý×Öµä
 SELECT  A.TABLE_NAME AS "±íÃû",A.COLUMN_NAME AS "×Ö¶ÎÃû",
 DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
 A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "×Ö¶ÎÀàÐÍ",A.DATA_DEFAULT AS "ĬÈÏÖµ",
A.NULLABLE AS "ÄÜ·ñΪ¿Õ",B.comments AS "±¸×¢"
from sys.all_tab_columns A,sys.DBA_COL_COMMENTS B
WHERE A.owner=B.owner AND A.table_name=B.table_name  AND A.COLUMN_NAME=B.COLUMN_NAME AND A.owner='guoqiang'  AND
A.TABLE_NAME IN (
'TB_SUBJECT', 'TB_SUBJECT_BALANCE', 'TB_VOUCHER', 'TB_VOUCHER_DETAILS',
'TB_CUSTOMER', 'TB_VOUCHER_CLASSIFY_MODE', 'TB_VOUCHER_TYPE', 'TB_ASSET',
'TB_ASSET_CATALOG', 'TB_M_DM_ASSETS_LIABI_RPT', 'TB_M_DM_PROFIT_RPT',
'TB_M_DM_REVENUE_RPT', 'TB_M_DM_COST_RPT'
)
ORDER BY A.TABLE_NAME
--Ò»°ãÓû§µ¼³ö¸ÃÓû§ÏµÄÊý¾Ý×Öµä
 SELECT  A.TABLE_NAME AS "±íÃû",A.COLUMN_NAME AS "×Ö¶ÎÃû",
 DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
 A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "×Ö¶ÎÀàÐÍ",A.DATA_DEFAULT AS "ĬÈÏÖµ",
A.NULLABLE AS "ÄÜ·ñΪ¿Õ",B.comments AS "±¸×¢"
from sys.user_tab_columns A,sys.user_col_comments B
WHERE A.table_name=B.table_name  AND A.COLUMN_NAME=B.COLUMN_NAME AND
A.TABLE_NAME IN (
'TB_SUBJECT', 'TB_SUBJECT_BALANCE', 'TB_VOUCHER', 'TB_VOUCHER_DETAILS',
'T
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/qingw