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
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