now if i execute the below query on ORACLE database :
SELECT LastName, DepartmentName FROM employee, department WHERE employee.DepartmentID = department.DepartmentID(+)
then i will get the below result
i will not get any department name for john as i have used left outer join.
so now my question is that if i want to put some default department name for all those entries for which department name is null then is there any way to do that like if i want to mention department name as "no department" for john then how can i do that?