Does varchar need length?

0 Answers  

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

---

What is a schema sql?

0 Answers  

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

What are the types pl/sql code blocks?

0 Answers  

---

What are character functions?

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,

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

What is bind reference and how can it be created?

0 Answers  

---

What are pl/sql packages?

0 Answers  

---

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

---