i have table(CORS_MTR) with 3 column..
| seq | prt id | child id | desc | |
|---|
| 100 | 22 | 1 | one | |
| 101 | 22 | 2 | two | new entry number as 1 ,it means change the flow of child # |
| 102 | 22 | 3 | three | |
when i enter new row in child number 1 to instead of 2 then the another column(child id,desc) values need to be reset like..
| seq | prt id | child id | desc |
|---|
| 100 | 22 | 2 | two |
| 101 | 22 | 1 | one |
| 102 | 22 | 3 | three |
| 103 | 22 | 4 | four |