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 |
4 rows affected
7 rows affected
ID | COMPANY_NAME | VAT_ID | URL | CREATED |
---|---|---|---|---|
1 | aaa | 123 | aaa.com | 2021-05-01 |
2 | bbb | 111 | bbb.de | 2021-05-01 |
3 | ccc | 345 | ccc.de | 2021-05-01 |
5 | ddd | 098 | ddd.de | 2021-05-21 |
TAG | ID | COMPANY_NAME | VAT_ID | URL | DELETE_FLAG |
---|---|---|---|---|---|
2021-05-25 | 1 | aaa | 123 | aaa.com | null |
2021-05-25 | 3 | ccc | 345 | ccc.de | null |
2021-05-25 | 4 | xxx | 789 | xxx.com | 1 |
2021-05-21 | 1 | aaa-2 | 123 | aaa.com | null |
2021-05-21 | 3 | ccc | 345-2 | ccc.de | null |
2021-05-20 | 1 | aaa-3 | 123-3 | aaa.com | null |
2021-05-20 | 2 | bbb | 111 | bbb.de | null |
LASTCHANGED | ID | COMPANY_NAME | VAT_ID | URL | DELETE_FLAG |
---|---|---|---|---|---|
2021-05-20 | 1 | aaa-3 | 123-3 | aaa.com | null |
2021-05-20 | 2 | bbb | 111 | bbb.de | null |
2021-05-21 | 3 | ccc | 345-2 | ccc.de | null |
2021-05-25 | 4 | xxx | 789 | xxx.com | 1 |
5 rows affected
ID | COMPANY_NAME | VAT_ID | URL | CREATED |
---|---|---|---|---|
1 | aaa | 123 | aaa.com | 2021-05-01 |
2 | bbb | 111 | bbb.de | 2021-05-01 |
3 | ccc | 345 | ccc.de | 2021-05-01 |
4 | xxx | 789 | xxx.com | 2021-05-01 |
5 | ddd | 098 | ddd.de | 2021-05-21 |
1 rows affected
dbms_output:
staged 5
copied 4
deleted 4
inserted 5