Is there a way to dump the contents of the oracle table into a file created as INSERT statements. I can not use oradump, as in the GPL. I will run it from the Perl CGI script. I am looking for something to flush data directly from oracle server with a single command. Running insert instructions and creating an insert using perl is too slow, because there will be a lot of data.
I know that perhaps this is possible with the spool command and the server side plsql block. But is there a built-in command to do this instead of creating INSERT statements yourself?
source
share