what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

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,

---

how to fetch common records from two tables? : Sql dba

0 Answers  

---

Can we create a trigger on view?

0 Answers  

---

Is record in oracle pl sql?

0 Answers  

---

What are field types?

0 Answers  

---

What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

---

How do I save a stored procedure?

0 Answers  

---

What is a left join?

0 Answers  

---

using comand prompt how can import table data and table space with example

2 Answers  

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

How does postgresql compare to mysql?

0 Answers  

---