Hi,
Need to delete all the records prior to pattern (INSERT/UPDATE/DELETE). If ' is available, then need to retain it.

Input

l_s := ' INSERT INTO TEST'
l_P PD := ' UPDATE INTO TEST'
l_D := ' DELETE INTO TEST'
This is test

Input

'INSERT INTO TEST'
'UPDATE INTO TEST'
'DELETE INTO TEST'
This is test

Bumping up posts or double posting is not permitted in these forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

Continue here:

Thank You.

The UNIX and Linux Forums.