This content has been marked as final. Show 2 replies
Wrong forum! This forum is for SQL Developer questions only and this question has nothing to do with sql developer.
Mark this question ANSWERED and post it in the sql and pl/sql forum.
SQL and PL/SQL
I have a specific requirement to delete some rows from a pl sql table. E.g. in the below code there are 2 rows in the table with pankaj as name. Could you please help me modify the code such that it deletes any one of them.
. . .
I tried the below code but it is deleting both the rows with pankaj as name.
That's because after you delete one you continue through the loop so it finds, and deletes, any others that exist. If you find one and delete it use EXIT to break out of the loop.
Mark this question ANSWERED and if you need more help with it you need to repost it in the proper forum.
Moving this question to SQL and PL SQL forum.