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: 39
Registered: April 2017
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

Report message to a moderator

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: 291
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

Report message to a moderator

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: 1971
Registered: December 2004
Senior Member
There are three types of fopen.
"R" - Read
"W" - overwrite
"A" - Append

Report message to a moderator

Previous Topic: Repeat Cursor
Next Topic: oracle external table load
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 09:48:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.