add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
BRANCHNO BOOKSHELFNO BOOKID BOOKSUPPLERNO
1234 4545 666 null
1234 4546 667 null
1234 4547 668 null
1234 4550 668 null
BOOKNO SUPPLIERNO
666 9112
667 9897
667 9998
668 9545
ORA-01427: single-row subquery returns more than one row
ORA-30926: unable to get a stable set of rows in the source tables
4 rows affected
BRANCHNO BOOKSHELFNO BOOKID BOOKSUPPLERNO
1234 4545 666 9112
1234 4546 667 9998
1234 4547 668 9545
1234 4550 668 9545
4 rows affected
BRANCHNO BOOKSHELFNO BOOKID BOOKSUPPLERNO
1234 4545 666 null
1234 4546 667 null
1234 4547 668 null
1234 4550 668 null
4 rows affected
BRANCHNO BOOKSHELFNO BOOKID BOOKSUPPLERNO
1234 4545 666 9112
1234 4546 667 9998
1234 4547 668 null
1234 4550 668 null
4 rows affected
BRANCHNO BOOKSHELFNO BOOKID BOOKSUPPLERNO
1234 4545 666 9112
1234 4546 667 9998
1234 4547 668 null
1234 4550 668 null
ORA-30926: unable to get a stable set of rows in the source tables