Here is the structure and data of the CUST_TRANS table:
Exhibit:
Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table.
Which three SQL statements would execute successfully? (Choose three.)
A. SELECT transdate + '10' FROM cust_trans;
B. SELECT * FROM cust_trans WHERE transdate = '01-01-07';
C. SELECT transamt FROM cust_trans WHERE custno > '11';
D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';
E. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;
Answer: A,C,D
Explanation:
表CUST_TRANS 列TRANSDATE是date类型
在英文版本的ORACLE中默认日期格式为'DD-MON-YY',例如'01-JAN-98'
A:对 日期类型可以和数字加减 E:错 日期类型不能和字母加减
B:错 赋值的日期格式不正确
C:对 日期类型可以查出来
D:对 日期格式为dd—month-yy 可以查 month为月份全称