'Creating Oracle Procedure To Update Table
I'm trying to create a procedure in an Oracle database that will update the PMBPCSB with an 'X' if any of the other columns have a value present. If all of the columns are NULL then I don't want it to do anything. I'm not exactly sure how to format the procedure to accomplish what I'm wanting. Any help is appreciated.
| COLUMN_NAME | DATA |
|---|---|
| PMBPCSB | |
| PMBPCFBB | |
| PMBPCHUB | |
| PMBCITNC | |
| PMBCITNSB | |
| PMBCSDB | |
| PMBCSDVOS | |
| PMBCVOSB | |
| PMBCWOB |
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|