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 |
What are joins in sql?
How does a self join work?
What does count (*) do in sql?
What is the use of nvl function?
what is collation? : Sql dba
Explain the update statement in sql
Can we use commit inside a trigger?
What will happen after commit statement ?
What is cross join sql?
How to fix oracle error ora-00942: table or view does not exist
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
What are the different types of functions in sql?
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)