What is a unique key and primary key and foreign key?

0 Answers  

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What are the two different parts of the pl/sql packages?

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

---

Can we rollback after truncate?

0 Answers  

---

How do you determine the current isolation level? : Transact sql

0 Answers  

---

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

---

How can we optimize a sql query?

0 Answers  

---

What is an ndf file?

0 Answers  

---

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

2 Answers  

---

How exception handling is done in advance pl/sql?

0 Answers  

---