Changes

J.Y.S

1 byte removed, 22:16, 19 October 2010

→‎4.

<pre>

SELECT SUBSTR(first_name||' '||last_name, 25) Employee, job_id,

LPAD(TO_CHAR(salary,'$~~999~~99,999'), 12, '=') Salary, department_name

FROM employees e JOIN departments d

USING (department_id)

1

edit