HI ALL,
I have a requirement on below table wherein I need to update the table with columns SFX and SEQ as in first I need to take maximum of SEQ and when its value reaches 99 i need to make SFX Column value to 02 and SEQ to 01. Please help me with th plsql procedure and update commands in it to achieve this.
Output as of now
Network
| PDF_PID
| LOC
| SFX
| SEQ
|
|---|
| MGCN | 100 | 2 | 01 | 01 |
| MGCN | 100 | 3 | 01 | 02 |
| MGCN | 100 | 23 | 01 | 99 |
| MGCN | 100 | 21 | 01 | 01 |
| MGCN | 50 | 1 | 01 | 02 |
Expected Output as below:
NETWORK
| PDF_PID | LOC
| SEQ
| SFX |
|---|
| MGCN | 100 | 2 | 01 | 01 |
| MGCN | 100 | 3 | 01 | 02 |
| MGCN | 100 | 23 | 01 | 99 |
| MGCN | 100 | 21 | 02 | 01 |
| MGCN | 50 | 1 | 01 | 01 |
pLEASE ELP!!!