Home » SQL & PL/SQL » SQL & PL/SQL » utl_file issue (oracle 11g)
utl_file issue [message #664546] Fri, 21 July 2017 14:49 Go to next message
POGAKU_SANTHOSH
Messages: 18
Registered: April 2017
Junior Member
hi team,

I have a requirement using utl_file concept where i need to get the data from a table and i need to append the data into that file using utl_file . can we do that append logic using utl_file .As per my knowledge i know only read and write can be done using utl_file. Can we use append logic in that ?

Thank you
Re: utl_file issue [message #664547 is a reply to message #664546] Fri, 21 July 2017 14:57 Go to previous messageGo to next message
Alien
Messages: 275
Registered: June 1999
Senior Member
Hi,

the Oracle documentation is actually quite good:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/u_file.htm#i1003526

Regards,

Alien
Re: utl_file issue [message #664548 is a reply to message #664547] Fri, 21 July 2017 15:16 Go to previous message
Bill B
Messages: 1701
Registered: December 2004
Senior Member
There are three types of fopen.
"R" - Read
"W" - overwrite
"A" - Append
Previous Topic: Repeat Cursor
Next Topic: oracle external table load
Goto Forum:
  


Current Time: Mon Dec 18 01:30:23 CST 2017

Total time taken to generate the page: 0.03212 seconds