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 |
Who i will insert 1 lacks record in a Database table
How to speed up webrick?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Differentiate between TRUNCATE and DELETE?
How to enter a new row into a table interactively?
How to call a sub procedure?
master table and child table performances and comparisons in Oracle ?
What are advantages of dateset in datastage?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
Give the Types of modules in a form?
How to pass a cursor variable to a procedure?