sql - Oracle Apex update specific row of table

Question

Hi i want to update a specific row of my oracle database via apex. So i need to reach/address the specific row via where clause.

example entries:

GATTUNG	ART	UNTERART	ABART	VARIET?T
AAA	AAA	AAA	NULL	NULL
AAA	AAA	NULL	NULL	AAA
AAA	AAA	NULL	NULL	NULL

question from:https://stackoverflow.com/questions/65892107/oracle-apex-update-specific-row-of-table

Answer 1

Does this do the trick ? It will update the rows if any of the columns have the same value as the corresponding page item or the database column and page item are both null:

UPDATE tbl_pflanze
   SET
  namen = :P1_NAMEN
 WHERE
  ( gattung = :P1_GATTUNG AND art = :P1_ART_KREUZUNG)
    AND
  ( ( NVL(unterart,'X') = NVL(:P1_UNTERART,'X')) AND
    ( NVL(variet?t,'X') = NVL(:P1_VARIETAET,'X')) AND
    ( NVL(abart,'X') = NVL(:P1_ABART,'X')) );