today:
211
yesterday:
310
Total:
1,017,507

-- Customer by Order --
SELECT distinct c.CUSTOMER_ID , initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME)  Name, o.ORDER_ID, O.ORDER_TOTAL  
FROM DEMO_CUSTOMERS C, DEMO_ORDERS O, DEMO_ORDER_ITEMS I
where C.CUSTOMER_ID   = O.CUSTOMER_ID   and
      I.ORDER_ID = O.ORDER_ID


-- Customer by Product --
SELECT distinct c.CUSTOMER_ID , initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME)  Name, p.product_id, P.PRODUCT_DESCRIPTION  
FROM DEMO_CUSTOMERS C, DEMO_ORDERS O, DEMO_ORDER_ITEMS I,  DEMO_PRODUCT_INFO P
where C.CUSTOMER_ID (+)  = O.CUSTOMER_ID   and
      I.ORDER_ID = O.ORDER_ID and
      I.PRODUCT_ID = p.product_id


-- Customer by Order and Product --
SELECT distinct c.CUSTOMER_ID , initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME)  Name, i.order_item_id,  p.product_id, P.PRODUCT_DESCRIPTION  
FROM DEMO_CUSTOMERS C, DEMO_ORDERS O, DEMO_ORDER_ITEMS I,  DEMO_PRODUCT_INFO P
where C.CUSTOMER_ID (+)  = O.CUSTOMER_ID   and
      I.ORDER_ID = O.ORDER_ID and
      I.PRODUCT_ID = p.product_id (+)


-- Customer By Order & Non Order --
SELECT c.CUSTOMER_ID,  initcap(C.CUST_FIRST_NAME || ' ' || C.CUST_LAST_NAME)  Name,  min(O.ORDER_ID) Order_id
FROM DEMO_CUSTOMERS C, DEMO_ORDERS O
where C.CUSTOMER_ID  = O.CUSTOMER_ID (+)
        group by c.CUSTOMER_ID, C.CUST_FIRST_NAME, C.CUST_LAST_NAME order by c.customer_id

No. Subject Author Date Views
126 ACTION admin 2019.01.11 6479
125 Fundamentals of PL/SQL admin 2016.05.10 2053
124 QR Code plugin admin 2017.11.30 1598
123 QR Code plugin Process admin 2017.11.30 968
122 How to Update Oracle XE Version admin 2018.02.23 946
121 GP PRINT admin 2018.05.31 933
120 INSTR admin 2016.05.19 814
119 SELECT last_name FROM admin 2018.12.12 768
118 IMP admin 2018.10.08 745
117 TREE admin 2016.05.18 740
116 JK admin 2019.02.05 717
115 CREATE TABLE admin 2018.09.25 491
114 APEX Password Change admin 2016.08.26 469
113 Membership Management admin 2016.06.09 454
112 JavaScript for Member List admin 2016.08.17 453
111 SQL admin 2016.07.15 416
110 QRCODE admin 2020.05.25 412
109 control break admin 2016.06.25 411
108 DATE Compare admin 2018.05.22 384
107 APEX Web Services Proxy Settings admin 2016.06.07 380