• 2022-10-26
    在Oracle中,表EMP包含以下列:[br][/br]……[br][/br]NAME VARCHAR2(20)[br][/br]ADDR VARCHAR2(60)[br][/br]……[br][/br]要以NAME’s address is ADDR格式返回数据,以下SQL语句正确的是(
    A: SELECT NAME || ’’’s address is ‘ || ADDR FROM EMP;
    B: SELECT NAME + ’’’s address is ‘ + ADDR FROM EMP;
    C: SELECT NAME + ’\’s address is ‘ + ADDR FROM EMP;
    D: SELECT NAME || ’\’s address is ‘ || ADDR FROM EMP;