Get some information about the table from the Oracle system table

xiaoxiao2021-03-31  204

It is used to SQLServer, and now it is very unhappy with Oracle, it feels too little information on your hand, and it is impressed inquiry. The following records a small trick: Select Obj #, DataObj #, Owner #, Name, Namespace, Subname, Type #, CTIME, MTIME, STIME, STATUS, Remoteowner, LinkName, Flags, Oid $, Spare1, Spare2, Spare3, SPARE4, Spare5, Spare6 from sys.obj $ This query can get all objects in Oracle, including table Select Obj #, Col #, Segcol #, Segcollength, Offset, Name, Type #, Length, FixedStorage, Precision #, Scale, Null $ , Deflength, Default, Intcol #, Property, CharsetId, Charsetform, Spare1, Spare2, Spare3, Spare4, Spare5, Spare6 from sys.col $ This query display table listing information OBJ # is foreign key.

转载请注明原文地址:https://www.9cbs.com/read-130922.html

New Post(0)