更新时间:2018-11-22 15:51作者:李一老师
7) you would like to display the system date in the format“20051110 14:44:17”。Which select statement should you use?______。
A、 select to_date(sydate,’yearmmdd hh:mm:ss’)from dual;
B、select to_char(sydate,’yearmonthday hh:mi:ss’)from dual;
C、select to_date(sydate,’yyyymmdd hh24:mi:ss’)from dual;
D、 select to_char(sydate,’yyyymmdd hh24:mi:ss’)from dual;
E、select to_char(sydate,’yy-mm-dd hh24:mi:ss’)from dual;
8)which select statement will the result ‘ello world’from the string‘Hello world’?______。
A、select substr(‘Hello World’,1)from dual;
B、select substr(trim(‘Hello World’,1,1))from dual;
C、select lower(substr(‘Hello World’,1))from dual;
D、select lower(trim(‘H’from‘Hello World’))from dual;
9)which are DML statements(choose all that apply)______。