Saturday, December 27, 2008

How to print result in oracle console


  set serveroutput ON;
DBMS_OUTPUT.PUT_LINE('some val')

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');