It looks like you have a very big chance of getting this question on your exam.
In first insert statement, we just created the first row by using standard syntax.
In second insert statement we’ve tried to insert same values but using subquery and it failed.
You should have used third insert statement in order to have values be inserted through a subquery. Just remove VALUES keyword and it will work.
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 first glance, this subquery looks absolutely legit. Unfortunately, it won’t work as a subquery but will work as a standalone query. […]
Both techniques are going to be tested during the exam. IN and EXISTS are not the same. And they work absolutely differently. IN picks […]
This is a typical error that many students do: The right answer is “07-MAY-1996”. The time component will not be displayed
