I want to fectch multiple record in the form of query by executing a sql query please give your inputs

Below query will fetch multiple records.

select * 
from KLG_RKS_PGL..AmountHist a
where a.SSNN not like '911%'
--and a.RevokeDate is null and a.PayFrequency='?'

Assuming pay frequency ‘?’ is wrong and we want to blank it out.

Now I want to write a query which will create update statements for all the rows returned from below where criteria to set pay frequency to blank.

Source: oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.