Interested to Buy Any Domain ? << Click Here >> for more details...
What is an UTL_FILE.What are different procedures and functions associated with it?
- 1 Answers
- 3317 Views
- I also Faced
- E-Mail Answers
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 do you mean by a deadlock?
How to speed up webrick?
what is Single Byte Overhead...?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is the difference between formal parameters and actual parameters?
material view and view disadvantages?
Why cursor variables are easier to use than cursors?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
primary key is foreign key for the same table?
How to synchronize 2 schema's objects?
Can group functions be mixed with non-group selection fields?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
Oracle General 
