1 Reply Latest reply: Dec 5, 2012 7:34 AM by Jeff Smith Sqldev Pm-Oracle RSS

    Excel import With Sequance Value

      I need to import data From Excel, but how i can set primary key from a Sequence value??
        • 1. Re: Excel import With Sequance Value
          Jeff Smith Sqldev Pm-Oracle
          You do it from outside the Excel -> Import wizard in SQL Developer.

          Define your table so your column is populated by a sequence. You can do this via an INSERT TRIGGER.

          When you define your Import scenario, leave the ID field alone, i.e. set it such that no values are passed, then your trigger will fire and the sequence.nextval will be used.