how to write utl file pkg in SQL
Answer / pankajsharma
l_utlfile=utl_file_type;
l_utlfile=utl_file.fopen('filepath','filename','mode')
| Is This Answer Correct ? | 5 Yes | 1 No |
How do I save the results of sql query in a file?
How do you handle exceptions. Give the syntax for it?
What are the different types of functions in sql?
counting the no.of characters occurs in a string by using pl/sql function
What are different categories of sql commands?
What is on delete restrict?
What is sql in oracle?
How do I remove sql plus from windows 10?
Why having clause is used in sql?
what is bcp? When does it used? : Sql dba
what is an extent ? : Sql dba
which will default fire first statement level trigger or row level trigger
2 Answers Cap Gemini, Data Vision,
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)