select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT

How will we see framework of a table?

Question Posted / sudheer kumar mikkilineni

Answer Posted / sudheer kumar mikkilineni

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from
dual;

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does sign mean sql?

1120

How many types of cursors are available in pl/sql?

1111

what are the difference between clustered and a non-clustered index? : Sql dba

1033

How many triggers can be applied on a table?

935

Can triggers stop a dml statement from executing on a table?

1102

How global cursor can be declare with dynamic trigger ?

2211

How to read xml file in oracle pl sql?

914

Why do we use %rowtype & %type in plsql?

1053

What is a join?

1072

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

991

Why do we create views in sql?

1155

what is text? : Sql dba

1075

Can we insert data into view?

907

Whis is not false in primary key?

1457

What is a parameter query?

1090