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 |
Define Transaction ?
What does ROLLBACK do ?
Explain the use of record length option in exp command.
What are inner join and outer join?
What is Water Mark in Oracle?
What are the different types of synonyms?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What do you mean by redo log file mirroring?
Give the advantages and disadvantages of clusters.
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
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.