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

what are the features and advantages of object-oriented programming? : Sql dba

0 Answers  

What are the steps for performance tuning.

0 Answers  

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

What is %type in pl sql?

0 Answers  

What is pl sql commands?

0 Answers  




How can I get the number of records affected by a stored procedure?

0 Answers  

What are tables in sql?

0 Answers  

What is sql integrity?

0 Answers  

How global cursor can be declare with dynamic trigger ?

0 Answers  

what are local and global variables and their differences? : Sql dba

0 Answers  

What are database links used for?

0 Answers  

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

For more SQL PLSQL Interview Questions Click Here
Categories