CODEWITHSUNDEEP
sqloracle-database
beshr
beshr

Reputation: 293

select statement oracle

I'm learning oracle sql from oracle sql fundamentals book, and i found this quiz, the answer as Oracle says 2,3 but they don't work on the sql developers

I know that they have to be like this

SELECT first_name, last_name, job_id, salary*12 "yearly_sal" FROM employees;

SELECT first_name, last_name, job_id, salary AS "yearly_sal" FROM employees;

but Oracle gives the answer as shown in the image below...

enter image description here

Upvotes: 0

Views: 1082

Answers (1)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60312

None of those answers are correct. Embedded spaces are only valid as column aliases if the alias is delimited by ". Also, + cannot be used to concatenate (what I assume to be) strings - instead you can use ||. They could be corrected as:

1.

SELECT first_name, last_name, job_id, salary*12 AS "Yearly Sal" FROM employees;

2.

SELECT first_name, last_name, job_id, salary*12 "yearly sal" FROM employees;

3.

SELECT first_name, last_name, job_id, salary AS "yearly sal" FROM employees;

4.

SELECT first_name || last_name AS name, job_Id, salary*12 "yearly sal" FROM employees;

Upvotes: 2

Related Questions