ChestNut’s Cake 好的遊戲帶領人會去關心人, 愛人, 且在神與人面前謙卑; 常常喜樂, 不住禱告, 凡事謝恩。 最重要的事就是來到上帝的面前禱告歸靈, 以致我的服侍可以把上帝的愛, 上帝的心意, 上帝的福音帶給人.

33愛的鼓勵 4訂閱站台

SELECT

  C.OWNER, C.TABLE_NAME, C.COLUMN_ID, C.COLUMN_NAME, 

  DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_DEFAULT, 

  NULLABLE, COMMENTS

FROM

  ALL_TAB_COLUMNS C 

JOIN ALL_TABLES T ON 

  C.OWNER = T.OWNER AND C.TABLE_NAME = T.TABLE_NAME

LEFT JOIN ALL_COL_COMMENTS R ON

  C.OWNER = R.Owner AND 

  C.TABLE_NAME = R.TABLE_NAME AND 

  C.COLUMN_NAME = R.COLUMN_NAME

WHERE  

  C.OWNER  = 'SCHEMA_NAME'

ORDER BY C.TABLE_NAME, C.COLUMN_ID

 

取得所有索引資料 

依資料表名稱、索引名稱、欄位順序、欄位名稱、排序方向(ASC/DESC)列出所有索引項目 
排版顯示純文字
SELECT 
  I.TABLE_OWNER, I.TABLE_NAME, I.INDEX_NAME, I.INDEX_TYPE,
  I.UNIQUENESS, C.COLUMN_POSITION, C.COLUMN_NAME, C.DESCEND
FROM 
  ALL_INDEXES I JOIN ALL_IND_COLUMNS C
ON 
  I.TABLE_OWNER = C.TABLE_OWNER AND
  I.INDEX_NAME = C.INDEX_NAME
WHERE
  C.TABLE_OWNER = 'SCHEMA_NAME'
ORDER BY I.TABLE_NAME, I.INDEX_NAME, COLUMN_POSITION

 


取得主鍵值(Primary Key)欄位 
排版顯示純文字
SELECT 
  C.OWNER, C.TABLE_NAME, D.POSITION, D.COLUMN_NAME  
FROM 
  ALL_CONSTRAINTS C JOIN ALL_CONS_COLUMNS D
ON
  C.OWNER = D.OWNER AND
  C.CONSTRAINT_NAME = D.CONSTRAINT_NAME
WHERE
  C.CONSTRAINT_TYPE = 'P' AND C.OWNER = 'SCHEMA_NAME'
ORDER BY C.TABLE_NAME, D.POSITION