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

What is difference between cartesian join and cross join?

591


How to experiment a data lock in oracle?

598


Explain the use of tables option in exp command.

593


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1473


List out the components of logical database structure of oracle database.

585






How to create a new table in oracle?

591


How to pass a cursor variable to a procedure?

562


What is the difference between "as" and "is" in an oracle stored procedure?

540


How to grant create session privilege to a user in oracle?

572


How would you begin to troubleshoot an ORA-3113 error?

1605


How to change system global area (sga) in oracle?

572


What do database buffers contain?

565


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1807


How to open a cursor variable?

611


How to convert a date to char in oracle? Give one example.

589