By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
ID | REGISTRATION_NUMBER | PRIMARY_NUMBER |
---|---|---|
132 | 000000001 | null |
151 | 000000002 | 000000001 |
SECONDARY_NUMBER | PERSON_ID |
---|---|
000000002 | 132 |
VALID_CODE |
---|
A1 |
N2 |
T1 |
REASON | PERSON_ID | TYPE_ID | ACTION_DATE |
---|---|---|---|
A1 | 132 | 1420 | 01-JAN-19 |
PERSON_ID | WOMAN_ACT |
---|---|
132 | X |
151 | X |
1 rows affected
1 rows affected
PERSON_ID | WOMAN_ACT |
---|---|
132 | X |
151 | X |
1 rows affected
PERSON_ID | WOMAN_ACT |
---|---|
132 | X |
151 | X |
345 | X |
1 rows affected
PERSON_ID | WOMAN_ACT |
---|---|
132 | X |
151 | X |
345 | X |
1 rows affected
PERSON_ID | WOMAN_ACT |
---|---|
132 | X |
151 | X |
345 | X |
1000 | X |
2000 | X |
ID | REGISTRATION_NUMBER | PRIMARY_NUMBER | WOMAN_ACT |
---|---|---|---|
132 | 000000001 | null | X |
151 | 000000002 | 000000001 | X |
345 | 000000345 | 000000001 | X |
1000 | 000000777 | null | X |
2000 | 000000778 | 000000777 | X |
1 rows affected
ID | REGISTRATION_NUMBER | PRIMARY_NUMBER | WOMAN_ACT |
---|---|---|---|
132 | 000000001 | null | X |
151 | 000000002 | 000000001 | X |
345 | 000000345 | 000000001 | X |
1000 | 000000777 | null | X |
2000 | 000000778 | 000000777 | X |
20000 | 000007778 | 000007777 | null |
10000 | 000007777 | null | null |