Hello,
When I pass value to application process, I'd like to do this: for apex_application.g_x01, if it's not null, then update column A; if not, don't update the column. So I wonder if there is some simpler query way to handle it (not NVL() since there is no default value to be assigned). For right now, I just use if apex_application.g_x01 is null, one update query; if not null, another update query. It's kind of repeating itself, not neat... thanks!