How do you declare a variable in pl sql?

0 Answers  

---

Temporary table vs Table variable in sql server?

0 Answers   Wipro,

---

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

---

Why are cursors used?

0 Answers  

---

What are different types of refreshment techniques of materialised view

2 Answers  

---

How do I copy a table in sql?

0 Answers  

---

What is the purpose of primary key?

0 Answers  

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

What is cursor in pl sql?

0 Answers  

---

How do I restart sql?

0 Answers  

---

Explain the savepoint statement.

0 Answers  

---

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  

---