How would you extract DDL of a table without using a GUI tool?
- 1 Answers
- 2565 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rahmat Islam
Without using a GUI tool, you can extract the Data Definition Language (DDL) of a table in Oracle by querying the DATA_DICT and USER_TABLES views. Here's an example script:nn```sqlnSET LONG 10000;nCOLUMN owner NEW_VALUE ownercolumn;nCOLUMN table_name NEW_VALUE tablename;nCOLUMN columns NEW_VALUE columnlist;nSELECT ownercolumn, tablename, DBMS_METADATA.GET_DDL('TABLE', '"' || ownercolumn || '."' || tablename || '"') AS columnsnFROM USER_TABLES WHERE table_name = 'your_table_name';n``` Replace 'your_table_name' with the name of your table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
