单项选择题
变量v_time=’23-MAY-00’, 如下那条语句返回值为’01-JAN-00’?()
A.select round(v_time,’DAY’) from dual B.select round(v_time,’YEAR’) from dual C.select round(v_time,’MONTH’) from dual D.A select round(to_char(v_time,’yyyy’)) from dual
单项选择题 如下语句:select i.id_number, m.id_number from inventory i, manufacturer m where i.manufacturer_id = m.id_number order by inventory.description 执行是错误的,请问以下措施哪个能够改正这个错误? ()
单项选择题 用truncate和delete语句删除表中数据的区别()
单项选择题 存在两个结构相同的数据库表T1(col1,col2,col3)、T2(col1,col2,col3),写出一SQL语句将所有T1数据导入到T2表()