Hi!

I am tryig to do the foll. query on sql * plus while the table (called CALL) is being loaded.

select max(pk_call) from call;

i have to end the task on windows NT for SQL * Plus. How can i grab this value at any instant.

Is it better to get the max value form the sequnce nstead? The primark key (pk_Call) gets its value from a sequence.

select call_seq.nextval from dual;

will the above work or will i run into the same problem again.

Thanks,
aruna