A.SYSTEM B.SYS C.SCOTT D.SYSDBA
A.sysdate; B.select sysdate; C.select sysdate from dual; D.select sysdate from common;
在Oracle中,表EMP包含以下列: …… NAME VARCHAR2(20) ADDR VARCHAR2(60) …… 要以NAME’s address is ADDR格式返回數(shù)據(jù),以下SQL語句正確的是()
A.SELECT NAME +’’’saddressis’ + ADDR FROM EMP B.SELECT NAME ∣∣ ’’’saddressis’ ∣∣ ADDR FROM EMP C.SELECT NAME +’\’saddressis’ + ADDR FROM EMP D.SELECT NAME ∣∣ ’\’saddressis’ ∣∣ ADDR FROM EMP