By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
NAME | SID | |
---|---|---|
user.mail1@domain.org | name_1 | 1 |
user.mail2@domain.org | name_2 | 2 |
user.mail3@domain.org | name_3 | 3 |
USERNAME | ADDRESS | DETAILS |
---|---|---|
1 | address_1 | details_1 |
user.mail1@domain.org | null | more details (user 1) |
2 | address_2 | details_2 |
user.mail2@domain.org | null | more details (user 2) |
3 | address_3 | details_3 |
user.mail3@domain.org | null | more details (user 3) |
3 | null | some more details (user 3) |
ORA-01732: data manipulation operation not legal on this view
ORA-01779: cannot modify a column which maps to a non key-preserved table
ORA-01427: single-row subquery returns more than one row
7 rows affected
NEW_ID | ADDRESS | DETAILS |
---|---|---|
1 | address_1 | details_1 |
1 | null | more details (user 1) |
2 | address_2 | details_2 |
2 | null | more details (user 2) |
3 | address_3 | details_3 |
3 | null | more details (user 3) |
3 | null | some more details (user 3) |
NAME | SID | NEW_ID | ADDRESS | DETAILS | |
---|---|---|---|---|---|
user.mail1@domain.org | name_1 | 1 | 1 | address_1 | details_1 |
user.mail1@domain.org | name_1 | 1 | 1 | null | more details (user 1) |
user.mail2@domain.org | name_2 | 2 | 2 | address_2 | details_2 |
user.mail2@domain.org | name_2 | 2 | 2 | null | more details (user 2) |
user.mail3@domain.org | name_3 | 3 | 3 | address_3 | details_3 |
user.mail3@domain.org | name_3 | 3 | 3 | null | more details (user 3) |
user.mail3@domain.org | name_3 | 3 | 3 | null | some more details (user 3) |