What is an UTL_FILE.What are different procedures and functions associated with it?
Answer / nishi
UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE, NEW_LINE, PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.
Is This Answer Correct ? | 0 Yes | 0 No |
What is a database table in oracle?
How many types of segments in Oracle?
Can we save images in a database and if yes, how?
Why does for update in oracle 8 cause an ora-01002 error?
How to list all user accounts in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
Explain the blob datatype?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What is the maximum number of triggers that can be applied to a single table?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What is a trigger and what are its types?
How to find the duplicate rows count from employees table in oracle?