Possible SQL question..?

I have a problem
: For the following instruction:
>
> insert into tabel1 select * from tabel2;
>
> If I have 1.000.000 of records which i must insert
> from tabel2 into tabel1 and it is an error.
> How could i detect where the error appears(at what
> rowid?)
>
> For example:
> Tabel1 has the records
> emp_id
> 1
> 2
> 3
> 4
> (error PK,FK,NOT NULL)
> 5
> 6
>
> Tabel2 has the following structure
> emp_id number not null
>
> For the following instruction:
>
> insert into tabel1 select * from tabel2;
>
> It detect an error
> My question:
> How could I find out that the error appears at the
> 5th
> record.

This is not a Newbie question, and we are an optical storage forum. Questions on SQL or whatever other database may not necessarily get an answer.

Let’s see though - transferring to General Software…