$($R$.$ Points$)$ Error Detection and Database Protection

A Leamine Outcome witi

Detabese Taning and Understand frror Detection $.$

Bolnts$)$ Let us consider the following Orade Database script!

create table source$\_$emp $($emp$,\_$id number primary key,

last$\_$name varchar$2(30),$ first$\_$name varchar$2(30))$;

insert into source$\_$emp values $(1,$'Robete','Diana'$)$:

Insert into source$\_$emp values $(2,,$ 'Diana'$)$;

insert into source$\_$emp values $(3,$'Simith','John'$)$;

create table target$\_$emp $($ emp$\_$id number primary key,

last$\_$name varchar$2(30)$ not null, first$\_$name varchar$2(30)$ not null$)$;

Explain why Insert into target$\_$emp select $*$ from source$\_$ emp; causes an error?

$($b$)(4$ Points$)$ How do you deal with the above error message using DBMS$\_$ERRLOG package and "log errors" dause?