What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

---

What is sql stand for?

0 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  

---

what is innodb? : Sql dba

0 Answers  

---

Which is faster truncate or drop?

0 Answers  

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

---

what are the forced views

6 Answers   Hexaware, TCS,

---

What is sql deadlock?

0 Answers  

---