Get detailed table(many other objects) structure with dbms_metadata
如果要快速瞭解一個表的每個欄位的基本資訊,可以透過 SQL> desc table_name 但是要獲取詳細的建表以及相關儲存資訊的話,可以使用dbms_metadata package,如下 SQL> set long 99999
SQL> set linesize 1000
SQL> set pagesize 160
SQL> select
dbms_metadata.get_ddl('TABLE','LEGAL_ENTITY') from dual;
除了table之外,還可以用於Index,FK,PK,Tablespace,user等物件,例如:
SQL> SELECT DBMS_METADATA.GET_DDL('INDEX','IDX_OBJECT_NAME') FROM DUAL;
SQL> SELECT DBMS_METADATA.GET_DDL('CONSTRAINT','PK_AA') FROM DUAL;
SQL> SELECT DBMS_METADATA.GET_DDL('REF_CONSTRAINT','FK_AA') FROM DUAL;
SQL> SELECT DBMS_METADATA.GET_DDL('TABLESPACE','EXAMPLE') FROM DUAL;
SQL> SELECT DBMS_METADATA.GET_DDL('USER','TEST') FROM DUAL;
[@more@]Reference : http://www.oracleblog.cn/study-note/more-about-dbmsmetadata/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12472709/viewspace-1036187/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Dependencies Among Other Remote Schema Objects (255)REMObject
- How To Efficiently Drop A Table With Many Extents
- Convert Array of Objects to Data TableObject
- [doc]How To Efficiently Drop A Table With Many Extents
- Oracle 19c Concepts(04):Partitions, Views, and Other Schema ObjectsOracleViewObject
- dbms_metadata包中的get_ddl函式詳細引數函式
- analyze table/index validate structure加鎖的問題IndexStruct
- Get table and index DDL in the easy way(轉)Index
- 資料庫 sqlite3_get_table,sqlite3_free_table資料庫SQLite
- 不用SE11建Structure傳Internal Table到Smartforms的方法StructORM
- Detailed Information on ODS and DSO objectAIORMObject
- [SDN] Detailed Information on ODS and DSO objectAIORMObject
- GORM many2many、many2one、one2many關聯表的操作GoORM
- LPI - Exam 102: Detailed ObjectivesAIObject
- LPI - Exam 101: Detailed ObjectivesAIObject
- data structureStruct
- Valuation StructureStruct
- DBMS_METADATA報錯解決方法
- Runloop + runtime + otherOOP
- OpenAPI Basic StructureAPIStruct
- VALIDATE STRUCTUREStruct
- Many To Many could not initialize proxy – no Session的解決方法Session
- oracle dbms_metadata 獲取ddl語句Oracle
- PHP函式庫(other)PHP函式
- Other SGA Initialization Parameters (96)
- Data Structure_樹Struct
- sqrt-data-structureStruct
- 【檢視】oracle 資料字典檢視之 DBA_OBJECTS / ALL_OBJECTS / USER_OBJECTS(OBJ)OracleObject
- Entity Framework Code-First(13):Configure Many-to-ManyFramework
- DBMS_METADATA包獲得物件DDL語句物件
- Oracle dba_objects和all_objects 最大的區別OracleObject
- mysqltoomanyconnections分析MySqlOOM
- 淺談Associated ObjectsObject
- Destroying Window ObjectsObject
- create objects inmemory optionsObject
- Naming Database ObjectsDatabaseObject
- Data block Structure and Row Piece Structure_20091209BloCStruct
- read by other session等待事件Session事件