What is difference between table and view?

0 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

Can you have a foreign key without a primary key?

0 Answers  

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

What is a subquery in sql?

0 Answers  

---

What are analytical functions in sql?

0 Answers  

---

What are the benefits of using PL/SQL packages?

3 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

What is having clause in sql?

0 Answers  

---

Give the order of sql select?

0 Answers  

---

what is the different between unique+not null & primary key,

4 Answers  

---

how can i read files from a pl/sq l program

3 Answers  

---