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.
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
7 rows affected
183400_Matches_number SCHEDULED_ON DAY_OF_WEEK
1 2020-06-15 Monday
2 2020-06-21 Sunday
3 2020-06-27 Saturday
4 2020-07-03 Friday
5 2020-07-09 Thursday
6 2020-07-15 Wednesday
7 2020-07-21 Tuesday
1 rows affected

dbms_output:
Match# 1 There are 0 updated rows
Match# 2 There are 1 updated rows
Match# 3 There are 1 updated rows
Match# 4 There are 0 updated rows
Match# 5 There are 0 updated rows
Match# 6 There are 0 updated rows
Match# 7 There are 0 updated rows
183400_Matches_number SCHEDULED_ON DAY_OF_WEEK
1 2020-06-15 Monday
2 2020-06-22 Monday
3 2020-06-26 Friday
4 2020-07-03 Friday
5 2020-07-09 Thursday
6 2020-07-15 Wednesday
7 2020-07-21 Tuesday