rename table in Oracle

Code

-- for person left outer join title
SELECT p.last_name, t.title_name
FROM person p, title t
WHERE p.title_1 = t.title_abbrev(+);

Reference

http://psoug.org/reference/joins.html