Home » RDBMS Server » Server Utilities » How to export a table data to a file.
How to export a table data to a file. [message #70551] Thu, 27 June 2002 23:00 Go to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
I have a requirement of writing the data of a table to a file (txt/dat). The values delimited by a comma. I come to know that UTL_FILE utility can be used for this. I tried an example using UTL_FILE, but not able to get the data in the text file. I also don't know how/where to set the dir path (UTL_FILE_DIR). Please give a solution. Thanks In Advance

Report message to a moderator

Re: How to export a table data to a file. [message #70559 is a reply to message #70551] Fri, 28 June 2002 20:28 Go to previous message
Ravi
Messages: 251
Registered: June 1998
Senior Member
I got the solution.

Report message to a moderator

Previous Topic: Re: how to copy table from user to another user
Next Topic: Transfering data from wordpad to database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 06:55:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.