請問各位ORACLE有像類似MS SQL的INFORMATION_SCHEMA
可以檢視資料庫資訊結構描述嗎?
例如：
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'CUSTOM_NO'
ORDER BY TABLE_NAME

就可以知道哪些TABLE裡有CUSTOM_NO欄位

try this...

SELECT COLUMN_ID, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE,NULLABLE
FROM SYS.ALL_TAB_COLUMNS
WHERE OWNER ='YOUR_ORA_OWNER' AND COLUMN_NAME = 'CUSTOM_NO' order by COLUMN_ID

ps: 看不到 Table 試著以有 Administrator 權限的 User 登入

編輯記錄