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 create a testing table in oracle?

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

Calculate difference between 2 date / times in oracle sql?

where we have to use ON clause and where we have to use USING clause in JOINS

How to define a data field as not null?

When system tablespace is created?

How to convert raw data type into text in oracle? Explain

which statement is running fastly ie insert or delete?

How to use existing values in update statements using oracle?

How to use "in" parameter properly?

How to convert a string to a date in oracle database?

How to increment dates by 1 in oracle?

For more Oracle General Interview Questions Click Here