Saturday, December 27, 2008

sequence(Oracle) Alternate to auto_increment(mysql)


   create a sequence
 create sequence test_d_seq  increment by 1 START WITH 1;
  insert value
insert into test_d values(test_d_seq.NEXTVAL,'Gex');

No comments:

Post a Comment