Oracle DBA Queries - Database status, uptime, how big is it, etc...
-- -- Get the DDL for a Given Table -- SELECT DBMS_METADATA.get_ddl ('TABLE', '&table_name', '&schema_name') FROM DUAL /