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 |