How would you extract DDL of a table without using a GUI tool?

Answer Posted / shafi.oracledba

to extract the ddl statement use the alter command to extract

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get maxsal , minsal, ename department wise in single query

1030


Explain oracle left join with an example?

594


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1706


What is using clause and give example?

593


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1574






how can we store any pdf file in oracle

1650


What is the disadvantage of User defind function?

1841


Can we store images in oracle database?

555


What is an oracle function?

606


Is oracle an open source?

640


How do I manually uninstall oracle client?

522


How can we view last record added to a table?

612


What is the quickest way to export a table to a flat file?

579


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1959


How to rollback the current transaction in oracle?

547