- 查看视图的创建语句
SELECT DBMS_METADATA.GET_DDL('VIEW','EPLUS_STAKE_QUERY_CONDITION') FROM DUAL;
- 查看表格的创建语句
SELECT DBMS_METADATA.GET_DDL('TABLE','I_USER') FROM DUAL;
SELECT DBMS_METADATA.GET_DDL('VIEW','EPLUS_STAKE_QUERY_CONDITION') FROM DUAL;
SELECT DBMS_METADATA.GET_DDL('TABLE','I_USER') FROM DUAL;