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,

---

Which sql statement is used to delete data from a database?

0 Answers  

---

How many rows will return from dual table?

4 Answers   Fujitsu,

---

How to connect a sql*plus session to an oracle server?

0 Answers  

---

tell us something about heap tables. : Sql dba

0 Answers  

---

---

What is pivot in sql?

0 Answers  

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

Which constraints we can use while creating database in sql?

0 Answers  

---

What is pl sql code?

0 Answers  

---