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

what are steps for interface? where is exchange rate defined in which table?

How to concatenate two text values in oracle?

What are the common oracle dba tasks?

What is an oracle transaction?

How do I spool to a csv formatted file using sqlplus?

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

What does sharding mean?

How to define a data source name (dsn) in odbc manager?

Difference between hot backup vs. Cold backup?

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

What are the different windows events activated at runtime ?

Explain an exception and its types?

For more Oracle General Interview Questions Click Here