ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(487)
发布时间:2019-03-01 11:53:56
Examine the structure of the SHIPMENTS table:You want to generate a report that displays the PO_ID and the penalty amount to be paid(罚款数额) if the SHIPMENT_DATE is later than one month from the PO_DATE. The penalty is $20 per day.SQL> SELECT po_id, CASETO_CHAR((shipment_date - po_da.........【阅读全文】