What is sharding in sql?

0 Answers  

---

Can we insert data into view?

0 Answers  

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What pl/sql package consists of?

0 Answers  

---

What are the two different parts of the pl/sql packages?

0 Answers  

---

What is the difference between subquery and correlated query?

0 Answers  

---

How to run sql statements with oracle sql developer?

0 Answers  

---

how can i create a user defined datatype

3 Answers  

---

What is sql comments?

0 Answers  

---