Answer / pankajsharma

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

What is a sql trace file?

0 Answers  

---

What type of join is sql join?

0 Answers  

---

What are the benefits of stored procedures?

0 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

how can you see all indexes defined for a table? : Sql dba

0 Answers  

---

---

display null value rows with out using null function?

8 Answers   Infosys,

---

Can we join two tables without common column?

0 Answers  

---

Is not null in sql?

0 Answers  

---

What is the use of sqlerrd 3?

0 Answers  

---

Which command is used to delete a package?

0 Answers  

---

How do you write a complex sql query?

0 Answers  

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

---