clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591639 fiddles created (45705 in the last week).

select * from V$VERSION;
BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production 0
 hidden batch(es)


create table books as select 1 BookID, 'Война и Мир' Title from dual union all select 2, 'Мир без Войн' from dual;
2 rows affected
 hidden batch(es)


create table tags as select 1 TagId, 'детское' TagName from dual union all select 2, 'роман' from dual;
2 rows affected
 hidden batch(es)


create table BookTags (BookId number, TagId number);
 hidden batch(es)


INSERT INTO BookTags (BookId, TagId) SELECT Books.BookID, Tags.TagId FROM Books, Tags WHERE Books.Title = 'Война и Мир' AND Tags.TagName = 'роман';
1 rows affected
 hidden batch(es)


SELECT * FROM BookTags;
BOOKID TAGID
1 2
 hidden batch(es)