摘要：1.sqlplus设置参数 set atuotrace onSET AUTOTRACE OFF --No AUTOTRACE report is generated. This is the default. SET AUTOTRACE ON EXPLAIN --The AUTOTRACE report shows only the optimizer execution path. SET AUTOTRACE ON STATISTICS --The AUTOTRACE report shows only the SQL statement execution ... 阅读全文

摘要：--GET_DDL: Return the metadata for a single object as DDL.-- This interface is meant for casual browsing (e.g., from SQLPlus)-- vs. the programmatic OPEN / FETCH / CLOSE interfaces above.-- PARAMETERS:-- object_type - The type of object to be retrieved.-- name - Name of the object.-- schema - Schema 阅读全文