| Please help me! [message #198242] |
Mon, 16 October 2006 04:49 |
|
|
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
> an error(NULL,PK)
> 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 because an emp_id is NULL
>
> My question:
> How could I find out that the error appears at the
> 5th
> record.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
