8-1 > @ A i 0.019 seconds B sblect distinct C.customer name, O.ship mode, O.ship

Question

8-1 > @ A i 0.019 seconds B sblect distinct C.customer name, O.ship mode, O.ship date froa customers c join orders 0 on C.customer id O.customer id where 0.3hipnode = 'secound class, and extract (YEAR from to char (0. ship date, M DD YYYY')) 2016 saipt Output x Error starting at line: Tin-command select distinct C.customer name, o.ship mode, o.ship date from customers C join orders o on c. customer-id =.customer id where 0.ship-mode = ' secound class' and extract (YEAR from to _char (0.ship date, 'M DD YYYY)) 2016 Error at Command Line: 4 Columm: 23 Error report- SQL Error: ORA-30076: invalid extract field for extract source 30076. 00000 "invalid extract field for extract source" Cause:The extract source does not contain the specified extract field. *Action: Start Page

Explanation / Answer

SELECT DISTINCT C.CUSTOMER_NAME , O.SHIP_MODE, O.SHIP_DATE FROM CUSTOMER C,
JOIN ORDERS O ON C.CUSTOMER_ID = O.CUSTOMER_ID
WHERE O.SHIP_MODE = 'second class'
AND EXTRACT (YEAR FROM TO_DATE(O.SHIP_DATE,MM-DD-YYYY)) > 2016;

PLEASE USE TO_DATE INSTEAD OF TO_CHAR ALSO CHANGE UNDERSCORE IN DATE FORMAT TO HYPEN

Related Questions

Navigate

• Browse (All)
• Browse 8
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.