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 the use of <> sql?

0 Answers  

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

How much ram can sql express use?

0 Answers  

---

How to test for null values?

0 Answers  

---

Can we have two clustered index on a table?

0 Answers  

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

what is bulk bind

4 Answers   TCS,

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

List out the acid properties and explain?

0 Answers  

---

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---

How many types of relationship are there?

0 Answers  

---