select dbms_metadata.get_ddl('TABLE','table name') FROM DUAL;
e.g:
select dbms_metadata.get_ddl('TABLE','ORDR') FROM DUAL;
About Me
- Anand Chavan
- Pune, Maharashtra, India
- Working on Oracle technology for more than 14+ years.Oracle Certified professional. Expertise in Oracle advance technologies like Oracle Real Application Cluster (RAC) , Oracle DataGuard, Oracle ASM, Oracle Golden gate. Experience in Area of migration/Replication of Oracle Database. Expertise in Storage/OS administration,Vertulization, Cloud technology. Activly involed in forum discussion of RAC sig and DBA village.
No comments:
Post a Comment