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

Question Posted / venkateswararao

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

Answer / shafi.oracledba

to extract the ddl statement use the alter command to extract

Is This Answer Correct ?

0 Yes

1 No

More Oracle General Interview Questions

How to establish administrator authentication to the server?

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

What are the components of Logical database structure of ORACLE database?

What is procedure overloading in oracle?

How can we create the complete backup of data in the oracle.

How to specify default values in insert statement using oracle?

waht is the difference between primary key and super key?

What is SYSTEM tablespace and When is it Created?

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

Difference between oracle's plus (+) notation and ansi join notation?

How to add another datafile to a tablespace?

For more Oracle General Interview Questions Click Here