Answer Posted / pankajsharma

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

What is union, minus and interact commands?

1306

---

Can we insert delete data in view?

954

---

How to know the last executed procedure?

1104

---

how to show all tables with 'mysql'? : Sql dba

1126

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

979

---

What is a .db file?

992

---

Can we join more than 2 tables in sql?

1030

---

Is sql scripting language?

1060

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1111

---

What is a column in a table?

1134

---

Is pl sql still used?

981

---

how to enter numeric values as hex numbers? : Sql dba

1073

---

How to find 3rd highest salary of an employee from the employee table in sql?

1083

---

How to Declare Fixed Length String Value In PL SQL

1158

---

what is rdbms? : Sql dba

1018

---