I'm fairly new to Oracle (and triggers particularly) but I need to do an auto-increment in Oracle 11g Express and SQL Developer. This is what I have so far:
CREATE TABLE theschema.thetable
(id NUMBER PRIMARY KEY,
CREATE SEQUENCE theschema.test1_sequence
START WITH 1
INCREMENT BY 1;
create or replace trigger insert_nums
before insert on theschema.thetable
for each row
select test1_sequence.nextval into :new.id from dual;
But when I tried to create a trigger, I keep getting a screen that asks me for some "binds." My dialog box has only one check box null. How can I make this script work? Thanks!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!