Does sap use sql?

0 Answers  

---

How to start the command-line sql*plus?

0 Answers  

---

Which is faster truncate or drop?

0 Answers  

---

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 the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

---

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---

What is a clob in sql?

0 Answers  

---

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

---

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  

---

define primary key & secondary key?

2 Answers  

---

What is the difference between partitioning and sharding?

0 Answers  

---