1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How will we see framework of a table?

Question Posted / avinash pradhan

Answers were Sorted based on User's Feedback



How will we see framework of a table?..

Answer / yam

to see the framework of table use

DESCRIBE tablename;
or DESC tablename

Is This Answer Correct ?    20 Yes 1 No

How will we see framework of a table?..

Answer / sudheer kumar mikkilineni

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

Is This Answer Correct ?    12 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Are stored procedures compiled?

0 Answers  

how view used for security purposes?

3 Answers   Glam India,

What are the benefits of pl sql?

0 Answers  

Can we use commit inside a trigger?

0 Answers  

Why do we use view in sql?

0 Answers  




Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

what is view? : Sql dba

0 Answers  

explain access control lists. : Sql dba

0 Answers  

Explain the difference between triggers and constraints?

0 Answers  

What is the purpose of the primary key?

0 Answers  

Why join is faster than subquery?

0 Answers  

How to process query result in pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories