SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Retrieve row count and append it to the file name while spooling a file

jimmy437Feb 11 2015 — edited Feb 11 2015

Hi,

I am using UNIX to execute a script in sqlplus and this script spools a file. I have used wc -l and got the record count but it takes for ever to do so(The file is huge, at least a million records are in it).

Is there a way that the row count can be appended to the filename in the script or pass the row count out so that I can handle the appending process in UNIX?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2015

Added on Feb 11 2015

3 comments

1,087 views