Write a select statement that uses a FULL JOIN to connect the

OE$.$PRODUCT$\_$INFORMATION table to the OE$.$CATEGORIES$\_$TAB table.

Refer to the ERD that you created in Week $1$ to determine what field you will need to

use to join the tables together.

$$ Project the CATEGORY$\_$NAME and CATEGORY$\_$ID fields

You may get an $$ORA$-00918$: column ambiguously defined$$ error. This is because category$\_$id

is defined in both tables and Oracle does not know which one you want to show, find a solution

to this common problem