Can One Read/write Files From Pl/sql?

1.	Can One Read/write Files From Pl/sql?
Answer» INCLUDED in Oracle 7.3 is a UTL_FILE package that can read and write files. The directory you intend writing to has to be in your INIT.ORA file (see UTL_FILE_DIR=... parameter). Before Oracle 7.3 the only MEANS of writing a file was to USE DBMS_OUTPUT with the SQLPlus SPOOL command. DECLARE fileHandler UTL_FILE.FILE_TYPE; BEGIN fileHandler := UTL_FILE.FOPEN('/home/oracle/tmp','myoutput','W'); UTL_FILE.PUTF(fileHandler, 'Value of func1 is %sn',func1(1)); UTL_FILE.FCLOSE(fileHandler); END; Included in Oracle 7.3 is a UTL_FILE package that can read and write files. The directory you intend writing to has to be in your INIT.ORA file (see UTL_FILE_DIR=... parameter). Before Oracle 7.3 the only means of writing a file was to use DBMS_OUTPUT with the SQLPlus SPOOL command.

Answer»

INCLUDED in Oracle 7.3 is a UTL_FILE package that can read and write files. The directory you intend writing to has to be in your INIT.ORA file (see UTL_FILE_DIR=... parameter). Before Oracle 7.3 the only MEANS of writing a file was to USE DBMS_OUTPUT with the SQL*Plus SPOOL command.

DECLARE fileHandler UTL_FILE.FILE_TYPE; BEGIN fileHandler := UTL_FILE.FOPEN('/home/oracle/tmp','myoutput','W'); UTL_FILE.PUTF(fileHandler, 'Value of func1 is %sn',func1(1)); UTL_FILE.FCLOSE(fileHandler); END;

Included in Oracle 7.3 is a UTL_FILE package that can read and write files. The directory you intend writing to has to be in your INIT.ORA file (see UTL_FILE_DIR=... parameter). Before Oracle 7.3 the only means of writing a file was to use DBMS_OUTPUT with the SQL*Plus SPOOL command.

Discussion

No Comment Found

Related InterviewSolutions

Do Stored Procedures And Functions Within The Same Schema Share The Same Namespace?
Give A Sql Statement So That The Procedure Proc_1 In The Package Pack_sample Is Granted Access To All The Users In The Database ?
Give A Sql Statement To Grant Access On The Procedure Proc_sample In The Schema, Schema_a.
Is It Possible To Create A Package Body And Store It In A Database?
Give The Sql Statement To Drop The Package Specification For Pack_a Without Dropping The Package Body ?
Suppose A Procedure Proc_1 Refers To A Procedure Proc_2 Within The Pack_1 Package. If The Definition Of The Proc_2 Procedure Is Changed And It Is Recompiled Again, Then Does The Proc_1 Procedure Is Invalidated ?
Explain The Grant And Revoke Dcl Statements ?
Which Data Dictionary View Will Give The Owner Name Along With The Privileges On A Schema Object?
Which Column In The User_sys_privs View Determines Whether The System Privilege Is With Admin Option ?
Write A Pl/sql Statement To Show The Privileges On A Procedure Proc_1 Within The Schema A ?