Live ORACLE

BEGIN

FOR item IN (SELECT first_name

                    ||' '

                    ||last_name AS full_name,

                    salary * 10 AS dream_salary

             FROM   employees

             WHERE  ROWNUM <= 5)

LOOP

  dbms_output.Put_line(item.full_name

                       ||' dreams of making '

                       ||item.dream_salary);

END LOOP;

END;

/

Donald OConnell dreams of making 26000
Douglas Grant dreams of making 26000
Jennifer Whalen dreams of making 44000
Michael Hartstein dreams of making 130000
Pat Fay dreams of making 60000

PL/SQL procedure successfully completed.

Using an Alias For Expressions in a Query