Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    5

    Unanswered: pl/sql(help me please) insert into

    I have the 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 record?)

    For example:
    Tabel1 has the records
    emp_id
    1
    2
    3
    4
    there will be a value which will product an error(PK,NOT NULL,FK)
    5
    6


    For the following instruction:

    insert into tabel1 select * from tabel2;

    It detect an error because of a constraint
    My question:
    How could I find out that the error appears at the
    5th
    record.

    Best regards,
    Virginia

  2. #2
    Join Date
    Mar 2004
    Location
    Warsaw / Poland
    Posts
    73

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •