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 sql connections encrypted?

0 Answers  

Whis is not false in primary key?

0 Answers   Fintellix,

Can we change the table name in sql?

0 Answers  

Why triggers are used?

0 Answers  

What are the types pl/sql code blocks?

0 Answers  




How do u count no of rows in a table?

8 Answers   CTS,

When do we create bitmap indexes

2 Answers   CTS,

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

Is sql pronounced sequel or sql?

0 Answers  

How to run sql functions in pl/sql?

0 Answers  

How many parts of a pl sql block are optional?

0 Answers  

Is drop table faster than truncate?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories