sample
Tables (3)
tbl_order_202101
- orderno — char(8)
- shopcode — char(4)
- orderdate — varchar2(8)
- pcode — char(4)
- amount — number(5)
tbl_product_202101
- pcode — char(4)
- pname — varchar2(30)
- cost — number(7)
tbl_shop_202101
- shopname — varchar2(20)
- shopcode — char(4)
- discount — number(2)