テーブル情報を取得するSQL。
SQL ----------------------------------------------------------------------------
SELECT TABLE_NAME
, COLUMN_NAME COLUMN
, DATA_TYPE DATA_TYPE
, NVL(DATA_PRECISION, CHAR_COL_DECL_LENGTH) LENGTH
, DATA_SCALE DECIMAL
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'TABLE_NAME'
ORDER BY TABLE_NAME
, COLUMN_ID
--------------------------------------------------------------------------------
何かに使えそう♪