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

Write a sql query to convert all character to uppercase after hypen.

1377

What is the difference among union, minus and intersect?

949

What is duration in sql profiler trace?

1022

How can a pl sql block be executed?

891

What is nosql vs sql?

1123

What are the topics in pl sql?

932

what is error ora-03113: end-of-file on communication channel?

1084

What is sql entity?

1031

how to use like conditions? : Sql dba

1040

What is a temp table?

950

What are the two virtual tables available at the time of database trigger execution?

1160

What is mutating error in pl sql?

965

What is mutating sql table?

1040

What is sqlerrm?

883

What is union and union all keyword in sql?

972