一、原题
View the Exhibit and examine the data in the EMPLOYEES table.
You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:
SQL> SELECT ename||' joined on '||hiredate||
', the total compensation paid is '||
TO_CHAR(ROUND(ROUND(SYSDATE-hiredate)/365) * sal + comm)
"COMPENSATION UNTIL DATE"
FROM employees;
What is the outcome?
A. It generates an error because the alias is not valid.
B. It execut
You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:
SQL> SELECT ename||' joined on '||hiredate||
', the total compensation paid is '||
TO_CHAR(ROUND(ROUND(SYSDATE-hiredate)/365) * sal + comm)
"COMPENSATION UNTIL DATE"
FROM employees;
What is the outcome?
A. It generates an error because the alias is not valid.
B. It execut