语句select LAST_DAY(‘2011-05-01’)from dual;的结果是()。
A、2011-05-28
B、2011-05-31
C、2011-04-30
D、2011-05-07
A、2011-05-28
B、2011-05-31
C、2011-04-30
D、2011-05-07
A、select last_date(sysdate) from dual; B、select finally_day(sysdate) from dual; C、select last_day(sysdate) from dual; D、select tail_day(sysdate) from dual;
A、FREQ = MONTHLY; BYMONTHDAY = 31 B、FREQ = MONTHLY; BYMONTHDAY = -1 C、FREQ = DAILY; BYDAY = -1 D、FREQ = MONTHLY; BYDAY = 31 E、FREQ = DAILY; BYMONTHDAY = LAST_DAY
A、A.SELECT last_name,12*salary* commission_pct FROM emp B、B.SELECT last_name,12*salary*(commission_pct,0)FROM emp C、C.SELECT last_name,12*salary*(nvl(commission_pct,0))FROM emp如果oracle第一个参数为空那么显示第二个参数的值,如果第一个参数的值不为空,则显示第一个参数本来的值 D、D.SELECT last_name,12*salary*(decode(commission_pct,0))FROM emp
A、SELECT &1, "&2" FROM &3 WHERE last_name = '&8'; B、SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8'; C、SELECT &1, &2 FROM &3 WHERE last_name = '&8'; D、SELECT &1, '&2' FROM EMP WHERE last_name = '&8';
A、SELECT &1, "&2" FROM &3 WHERE last_name = '&4'; B、SELECT &1, '&2' FROM &3 WHERE '&last_name = '&4''; C、SELECT &1, &2 FROM &3 WHERE last_name = '&4'; D、SELECT &1, '&2' FROM EMP WHERE last_name = '&4';
A、A. SELECT &1, "&2" FROM &3 WHERE last_name = '&8'; B、B. SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8'; C、C. SELECT &1, &2 FROM &3 WHERE last_name = '&8'; D、D. SELECT &1, '&2' FROM EMP WHERE last_name = '&8';
A、 FREQ = MONTHLY; BYMONTHDAY = 31 B、 FREQ = MONTHLY; BYMONTHDAY = -1 C、 FREQ = DAILY; BYDAY = -1 D、 FREQ = MONTHLY; BYDAY = 31 E、 FREQ = DAILY; BYMONTHDAY = LAST_DAY
A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%'; B、SELECT last_name FROM EMP WHERE last name ='*A%' C、SELECT last_name FROM EMP WHERE last name ='_A%'; D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'
A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%'; B、SELECT last_name FROM EMP WHERE last name ='*A%' C、SELECT last_name FROM EMP WHERE last name ='_A%'; D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'