my favorite

2008/03/11

取得Oracle資料庫的特定表格資訊

SELECT
table_name,
column_name,
column_id,
data_type,
data_length, /* 欄位長度 */
data_precision, /* 精確度 : Number型態整數位數 */
data_scale /* 精確度 : Number型態小數點位數 */
FROM SYS.all_tab_columns
WHERE owner = 'schema_name'
AND
table_name = 'table_name'
ORDER BY table_name, column_id

No comments:

BIO

Taipei, GuTing, Taiwan

huang47 | personal

huang47 | personal