What are primary key and foreign key and how they work?

0 Answers  

---

What are schema-level triggers?

0 Answers  

---

How do you declare a variable in pl sql?

0 Answers  

---

how to select unique records from a table? : Sql dba

0 Answers  

---

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

---

What are the types of views in sql?

0 Answers  

---

What does where 1 1 mean in sql?

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

Can we insert data into materialized view?

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  

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---