SELECT
table_name as テーブル名,
column_name カラム名,
(case
WHEN data_type = 'VARCHAR2' THEN data_type || '(' || nvl(data_precision,data_length) ||')'
WHEN data_type = 'NUMBER' THEN
data_type || '(' || nvl(data_precision,data_length) || ',' || nvl(data_scale,'0') ||')'
ELSE data_type
END
) as データテープ
,nullable 非必須
FROM
user_tab_columns
WHERE
table_name = IN_VCHR_TABLE_NAME
Order by column_id
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme