Language: Highlight Mode: PLSQL Last Modified: March 07th, 2009
SELECT p.last_name, t.title_name
FROM person p, title t
WHERE p.title_1 = t.title_abbrev;SELECT p.last_name, r.role_name
FROM person p, person_role_ie i, person_role r
WHERE p.person_id = i.person_id
AND i.role_id = r.role_id;
Left Outer Join
SELECT p.last_name, t.title_name
FROM person p, role r
WHERE p.title_1 = r.title(+);
Returns ALL records FROM role TABLEANDALL matching records FROM person TABLE
Right Outer Join
SELECT p.last_name, t.title_name
FROM person p, role r
WHERE p.title_1 (+)= r.title;
Returns ALL records FROM person TABLEANDALL matching records FROM role TABLE
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.
