Retrieving a Table count from sqlplus back into kornshell

From: Rinkan Patel <rinkan786_at_yahoo.com>
Date: 20 Jul 2001 13:48:26 -0700
Message-ID: <5985ee07.0107201248.6780e614@posting.google.com>

Hi:

I am new to scripting in the UNIX environment and I am having a problem figuring out a way that I can compare counts from a Oracle table, before a purge and after a purge. I want to capture the count from sqlplus in a UNIX variable, where I can do the compare on the UNIX side. Is this Possible and if so how? Also, Question 2: If I return to UNIX while connected with a session open will my session on Oracle end, because I have to either COMMIT or ROLLBACK the transaction depending on the count comparison?? Is there a better way to do this, please let me know.

Thank you,
Rinkan Patel
rinkan786_at_yahoo.com Received on Fri Jul 20 2001 - 15:48:26 CDT