How do I run sql?

0 Answers  

---

What is the differnce between view and materialized view

4 Answers   TCS,

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

Explain the insert into statements in sql?

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  

---

---

What is package in pl sql?

0 Answers  

---

Does inner join return duplicate rows?

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

real time applications of nullif?

3 Answers  

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---