Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

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  

---

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

---

What is minus?

0 Answers  

---

Can a foreign key be null?

0 Answers  

---

Why do we use subquery?

0 Answers  

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

---

What are literals in sql server?

0 Answers  

---

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

1 Answers   AOL,

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

What is rownum in sql?

0 Answers  

---