Answer / yam

to see the framework of table use

DESCRIBE tablename;
or DESC tablename

Answer / sudheer kumar mikkilineni

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

What is RAC in oracle?

7 Answers   MCN Solutions,

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

What is difference between hql and sql?

0 Answers  

---

What are the different types of functions in sql?

0 Answers  

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

What is exception? What are the types of exceptions?

0 Answers  

---

How can we schedule the procedure to run automatically ?

3 Answers  

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

Mention what does plv msg allows you to do?

0 Answers  

---

how will i became good database developer?

1 Answers  

---

Can we join tables without foreign key?

0 Answers  

---

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

---