Answer Posted / pankajsharma

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

What do you mean by stored procedures? How do we use it?

517

---

what is rdbms? : Sql dba

570

---

Why sql query is slow?

573

---

Explain cursor types?

572

---

What are sql built in functions?

504

---

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

552

---

What does the base_object_type column shows in the user.triggers data dictionary view?

566

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

553

---

What are the different schemas objects that can be created using pl/sql?

520

---

How to use sql statements in pl/sql?

576

---

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

597

---

what are wild cards used in database for pattern matching ? : Sql dba

540

---

What are sql injection vulnerabilities?

493

---

What does count (*) mean?

517

---

what is the stuff function and how does it differ from the replace function? : Sql dba

615

---