Answer / pankajsharma

l_utlfile=utl_file_type;
l_utlfile=utl_file.fopen('filepath','filename','mode')

Explain polymorphism in pl/sql.

0 Answers  

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

What is the difference between syntax error and runtime error?

0 Answers  

---

How is a process of pl/sql compiled?

0 Answers  

---

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

---

---

What do you understand by case manipulation functions?

0 Answers  

---

How do I save a stored procedure?

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  

---

Which is faster truncate or drop?

0 Answers  

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---

What is the size of partition table?

0 Answers  

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---