Help with Oracle SQL*Plus Query assignment

Discussion in 'Databases' started by skullcane, Jan 20, 2012.

  1. #1
    Hey,


    I'm currently working on a lab assignment for class.


    Assignment is located here:
    hal.cs.camosun (dot) bc.ca/~weston/comp155/tyo/Lab3.html


    The assignment states to write 3 queries in both the SQL:1999 version and the SQL Traditional (older version)


    I didn't read that part, and so I created 3 queries and I don't know which ones are 1999 and which ones are traditional.


    I would really appreciate it if someone helps me sort this problem out


    So overall I need to have 6 queries in total. 3 for the SQL 1999 version and 3 for the SQL traditional (older) version


    1.)


    SELECT e.last_name, e.job_id, e.department_id, d.department_name
    FROM employees e JOIN departments d
    ON (e.department_id = d.department_id)
    JOIN locations l
    ON (d.location_id = l.location_id)
    WHERE LOWER(l.city) = 'toronto';


    2.)


    SELECT e.last_name, d.department_name
    FROM employees e, departments d
    WHERE e.department_id = d.department_id AND last_name LIKE 'G%';


    3.)


    SELECT e.last_name "Employee", e.employee_id "Emp#", m.last_name "Manager", m.employee_id "Mgr#"
    FROM employees e INNER JOIN employees m
    ON e.manager_id = m.employee_id
    AND UPPER(e.last_name) LIKE 'G%';


    Thanks
     
    skullcane, Jan 20, 2012 IP