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. 2805438 fiddles created (40821 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 t as with cte as ( select 1 woid,'abc' words from dual union all select 2 woid,'abc1' words from dual ) select * from cte
2 rows affected
 hidden batch(es)


--обновляем таблицу (cte) update t set words = 'qwe' where woid = 1
1 rows affected
 hidden batch(es)


select * from t
WOID WORDS
1 qwe
2 abc1
 hidden batch(es)


--после проверки коммит commit;
 hidden batch(es)