what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

Does truncate free space?

0 Answers  

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  

---

What is use of package in pl sql?

0 Answers  

---

What is difference between triggers and stored procedures. And advantages of SP over triggers ?

4 Answers   Microsoft, TCS,

---

what is meant by forward declaration in functions?

4 Answers   TCS,

---

What is the usage of when clause in trigger?

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 are database links used for?

0 Answers  

---

what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

---

Does asenumerable execute the query?

0 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---