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

Explain the select statement in sql?

1109

What is the benefit of foreign key?

1022

What do you mean by “trigger” in sql?

1077

Mention what are the benefits of pl/sql packages?

1080

Is sql database free?

973

Can I create table without primary key?

997

How do you optimize a stored procedure in sql?

957

How many times can we commit in a loop?

1017

What is t sql in sql server?

1074

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1000

Is sql sequential or random?

1031

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1047

What is the current version of postgresql?

1065

What are all ddl commands?

1083

What is rtm stands for?

1095