gotetioracle
asked on
Text File generation in oracle
Can anybody tell me, how to generate text file in oracle without using UTL_FILE_DIR ?
SOLUTION
![Avatar of Alex [***Alex140181***]](https://filedb.experts-exchange.com/files/public/2022/11/13/8257e912-ee3c-4a93-9df0-fe9a8a1515cf.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did you READ the chapter from my link above?!? -> no use of UTL_FILE
ASKER
i read but the document does not tell how to write a data from a table to a csv file.
I'm a little confused. Are you trying to avoid using the UTL_FILE_DIR parameter, or the UTL_FILE package.
You can use UTL_FILE without setting UTL_FILE_DIR. You just have to have a directory object within Oracle that points to the directory where you want the file to be placed. They are created with the CREATE DIRECTORY command. Doc for CREATE DIRECTORY -> http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5007.htm#i2061958
You can use UTL_FILE without setting UTL_FILE_DIR. You just have to have a directory object within Oracle that points to the directory where you want the file to be placed. They are created with the CREATE DIRECTORY command. Doc for CREATE DIRECTORY -> http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5007.htm#i2061958
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I want to generate a text file from the sql query output without using UTL_FILE_DIR .
Regards,
GSK