Unfortunately, FULL OUTER JOIN does not work with traditional Oracle join syntax. You cannot do something like this :
select e.last_name, e.first_name, t.task_name
from employee e, task t
where e.employee_id(+) = t.employee_id(+);
You can only engage FULL OUTER JOIN with ANSI syntax like this :
select e.last_name, e.first_name, t.task_name
from employee e FULL OUTER JOIN task t
ON (e.employee_id = t.employee_id ) ;
This is another tricky example that worth your attention. When you adding a column with a DEFAULT value specified, then this default […]
There are some questions on the exam to verify your knowledge about finding the second highest value of the table or column. […]
You can’t apply <> operator to fetch NON NULL data. It won’t return any data, though won’t produce any error either. See below. […]
If you have a table with existing data ( as shown below) and you’ve been asked to add a NOT NULL column […]
