[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*) into L_count
from all_sequences
where sequence_name = X_name
and sequence_owner = l_schema;
select last_number into L_chkLastNumber
from all_sequences
where sequence_name = X_name
and sequence_owner = l_schema;