Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jul 2011
    Posts
    17
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Help with Oracle SQL*Plus Query assignment

    Hey,

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

    Assignment is located here:
    http://hal.cs.camosun.bc.ca/~weston/.../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
    Last edited by tridentspk; 01-21-2012 at 04:57 AM.

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,603
    Thanks
    80
    Thanked 4,634 Times in 4,596 Posts
    You posted in the MySQL forum, so expect your post to be moved to the "other databases" forum soon.

    But in any case, there aren't many Oracle people who hang out around here.

    SQL 1999 seems ancient, to me. I would think the *IT* would be the "traditional" SQL. Sounds like Oracle is still a bit out of date compared to most products,

    *IF* I were guessing, I'd say that the use of the keyword JOIN means the newer version and the older version is just done using WHERE clauses.

    I know that many many many years ago we used to use *= for a LEFT JOIN.

    That is
    Code:
    SELECT ...
    FROM a *= b WHERE a.x = b.x
    was really old notation for
    Code:
    SELECT ...
    FROM a LEFT JOIN b ON a.x = b.x
    But that's more like 1985 to 1990 or so, in the SQL Server world. Much older than SQL 1999.

    You will pardon me, I hope, for saying this seems like a useless exercise. Nobody in their right mind would use a SQL dialect older than 1999 for any real world work today.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •