This content has been marked as final. Show 3 replies
This is a SQL & PL/SQL forum. For Question related to Oracle Form and Reports, Please Post in the forum below:
If I am Clear, the exit statement should be removed from the line when you find the first match,so as to go
to the next match till the last record.
And, You search the text to be compared, with all the records in the block navigating all the items in the block
one by once till the last record is reached which is satisfied by the condition :system.last_record ='TRUE';
And, Please mark the question as answered when you leave the forum.