How to read/write files from PL/SQL?
devquora
Posted On: Feb 22, 2018
Oracle 7.3 has a UTL_FILE package included in it which is used to read/ write files. The directory where you want to write to has to be in the INIT.ORA file. Prior to Oracle 7.3, DBMS_OUTPUT with the SQL*Plus SPOOL command was the only way to write a file.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Oracle Interview Questions
What is Oracle?
Oracle is a database server that is used to handle data in a structured manner. It lets its users to retrieve and to st..
Oracle Interview Questions
Define Oracle database
An Oracle database can be termed as a compilation of data housed in a database server and treated like a large unit...
Oracle Interview Questions
Explain Oracle instance.
Each operating Oracle database is associated with an Oracle instance. As soon as a database server starts the database,..