一、原题 View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the PROMOTIONS table, and the required output format. Which two queries give the correct result? (Choose two.) A. SELECT promo_name, TO_CHAR(promo_end_date,D…
一、原题 Examine the structure of the TRANSACTIONS table: Name Null Type TRANS_ID NOT NULL NUMBER(3) CUST_NAME VARCHAR2(30) TRANS_DATE DATE TRANS_AMT NUMBER(10,2) You want to disp…
一、原题 View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CUST_LAST_NAME column contains the values Anderson and Ausson. You issue the following query: SQL> SELECT LOWER(REPLACE(TRIM(son FROM cust_last_nam…