add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
EMAIL 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)
EMAIL 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)