Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete rows based on Filter condition

srikanth bSep 28 2021

image.pngExpected Result:
image.pngMy effort
DELETE FROM ETL.STG_DW_ACCT_GRP
WHERE STG_DW_LOAD_DT >= '27-SEP-21'
AND ACCT_GRP_CD= '829'
AND ACCT_GRP_NM = 'Z HEB'
AND ACCT_GRP_DESC='Z HEB'
Comments
Post Details
Added on Sep 28 2021
#pl-sql, #sqldeveloper
2 comments
748 views