Oracle SQL: How to Generate DDL/Creation Script of Any Database Object
This Video Will Explain How to Generate DDL/Creation Script of Any Database Object
The SQL Query is given below:
SELECT DBMS_METADATA.get_ddl ('TABLE', 'STUDENTS', 'ADMIN') FROM DUAL;