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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.