Can sql developer connect to db2?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

What is duration in sql profiler trace?

0 Answers  

---

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

What is pivot table in sql?

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  

---

Why is sharding used?

0 Answers  

---

Is pl sql useful?

0 Answers  

---

Do we need to rebuild index after truncate?

0 Answers  

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---