Link to home
Start Free TrialLog in
Avatar of sam2929
sam2929

asked on

disable to identity key then enable once data is inserted

Hi ,
I am creating table like below:

CREATE TABLE ANSWER
  (
  ANSWER_ID NUMBER (8) GENERATED ALWAYS AS IDENTITY (
    START WITH 1 CACHE 20 ) NOT NULL ,
    QUESTION_ID NUMBER (8) NOT NULL ,
  answer_desc
)

i have data in that table

2,101 testa
3,101 testb
4 102 fana
5  102 fanb

Now i want to move code in test

how can i disable  ANSWER_ID  in test and just insert the data from dev and then enable it lets say from 500
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial