Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();
ORA-00923: FROM keyword not found where expected

create table prodtext as
    with data (product_id, attribute_id, language_id, text) as (
        select 68 , 22, 1, trim ('Натуральная кожа  ') from dual union all
        select 68 , 22, 2, trim ('Натуральная кожа  ') from dual union all
        select 168, 23, 1, trim ('Искусственная кожа') from dual union all
        select 168, 23, 2, trim ('                  ') from dual union all
        select 168, 32, 1, trim ('Картон            ') from dual union all
        select 168, 32, 2, trim ('                  ') from dual union all
        select 681, 12, 1, trim ('Бумага            ') from dual union all
        select 681, 12, 2, trim ('                  ') from dual)
    select * from data 
8 rows affected

create table languages as
    select 1 id, 'ru' lang from dual union all  
    select 2 id, 'en' lang from dual union all  
    select 3 id, 'de' lang from dual
3 rows affected

select * from prodtext


PRODUCT_ID
ATTRIBUTE_ID
LANGUAGE_ID
TEXT


68
22
1
?????????????????????? ????????

68
22
2
?????????????????????? ????????

168
23
1
?????????????????????????? ????????

168
23
2
null

168
32
1
????????????

168
32
2
null

681
12
1
????????????

681
12
2
null

PRODUCT_ID	ATTRIBUTE_ID	LANGUAGE_ID	TEXT
68	22	1	?????????????????????? ????????
68	22	2	?????????????????????? ????????
168	23	1	?????????????????????????? ????????
168	23	2	null
168	32	1	????????????
168	32	2	null
681	12	1	????????????
681	12	2	null