add batch
remove batch
split batch
comment selection
show hidden batches
hide batch
highlight batch
db<>fiddle
Db2
Firebird
MariaDB
MySQL
Node.js
Oracle
Postgres
SQLite
SQL Server
TimescaleDB
YugabyteDB
Developer-C 11.1
3.0
4.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
5.5
5.6
5.7
8.0
18
11g Release 2
18c
21c
23c
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
3.8
3.16
3.27
3.39
2012
2014
2016
2017
2017 (Linux)
2019
2019 (Linux)
2022
2.11
2.6
2.8
2.18
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
run
markdown
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
create table rpm_future_retail ( FUTURE_RETAIL_ID number(20) primary key, item varchar2(20), location number(5), action_date date, SELLING_RETAIL number(10,4), SELLING_RETAIL_CURRENCY varchar2(3), SELLING_UOM varchar2(2));
create table rpm_zone_future_retail ( ZONE_FUTURE_RETAIL_ID number(20) primary key, item varchar2(20), ZONE number(2), action_date date, SELLING_RETAIL number(10,4), SELLING_RETAIL_CURRENCY varchar2(3), SELLING_UOM varchar2(2));
create table rpm_zone_location (zone_id number(2), location number(4));
insert into rpm_future_retail (FUTURE_RETAIL_ID, ITEM, LOCATION, ACTION_DATE, SELLING_RETAIL, SELLING_RETAIL_CURRENCY, SELLING_UOM) SELECT 10423932823, '050234056', 3494, to_date('04-01-2018', 'dd-mm-yyyy'), 13.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 11727883688, '050234056', 3500, to_date('04-01-2018', 'dd-mm-yyyy'), 13.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 11727885218, '050234056', 3501, to_date('04-01-2018', 'dd-mm-yyyy'), 13.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 10423932825, '050234056', 3502, to_date('13-11-2017', 'dd-mm-yyyy'), 15.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 10423932831, '050234056', 3503, to_date('04-01-2018', 'dd-mm-yyyy'), 13.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 10423932877, '050234056', 3504, to_date('04-01-2018', 'dd-mm-yyyy'), 13.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 11727887165, '050234056', 3505, to_date('13-11-2017', 'dd-mm-yyyy'), 15.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 11727887666, '050234056', 3506, to_date('04-01-2018', 'dd-mm-yyyy'), 13.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 10423933087, '050234056', 3492, to_date('04-01-2018', 'dd-mm-yyyy'), 13.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 10423933088, '050234056', 3494, to_date('13-11-2017', 'dd-mm-yyyy'), 15.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 11793175015, '050234056', 3500, to_date('13-11-2017', 'dd-mm-yyyy'), 15.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 11727889670, '050234056', 3501, to_date('13-11-2017', 'dd-mm-yyyy'), 15.8900, 'GBP', 'EA' FROM DUAL;
12 rows affected
insert into rpm_zone_future_retail (ZONE_FUTURE_RETAIL_ID, ITEM, ZONE, ACTION_DATE, SELLING_RETAIL, SELLING_RETAIL_CURRENCY, SELLING_UOM) SELECT 608942489, '050233719', 2, to_date('05-01-2018', 'dd-mm-yyyy'), 16.0000, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 614108453, '050234845', 3, to_date('21-11-2017', 'dd-mm-yyyy'), 12.0000, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 608942141, '050234056', 2, to_date('04-01-2018', 'dd-mm-yyyy'), 13.8900, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 614108616, '050374500', 2, to_date('03-01-2018', 'dd-mm-yyyy'), 4.5000, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 614108613, '050245008', 11, to_date('31-07-2013', 'dd-mm-yyyy'), 4.5400, 'EUR', 'EA' FROM DUAL UNION ALL SELECT 614108554, '050244977', 2, to_date('03-01-2018', 'dd-mm-yyyy'), 6.5400, 'GBP', 'EA' FROM DUAL UNION ALL SELECT 614108525, '050244977', 1, to_date('03-01-2018', 'dd-mm-yyyy'), 6.5400, 'GBP', 'EA' FROM DUAL;
7 rows affected
insert into rpm_zone_location (ZONE_ID, LOCATION) SELECT 1, 2030 FROM DUAL UNION ALL SELECT 1, 2031 FROM DUAL UNION ALL SELECT 3, 2853 FROM DUAL UNION ALL SELECT 3, 5869 FROM DUAL UNION ALL SELECT 2, 3492 FROM DUAL UNION ALL SELECT 2, 3512 FROM DUAL ;
6 rows affected