[ subclipse ]svn:ignore files in the directory

1. Click at the folder, Team > Show Properties

2. After that add the property svn:ignore i.e. ignore all the excel files in the directory

รูปภาพ

Advertisements

oracle autoincrement

1. create sequence

CREATE SEQUENCE test_sequence

START WITH 1
INCREMENT BY 1;

2. create trigger

รูปภาพ

CREATE OR REPLACE TRIGGER (trigger_name)
BEFORE INSERT ON (table_name)
REFERENCING NEW AS N
FOR EACH ROW
BEGIN
SELECT (sequence_name).nextval INTO :N.(column_name) FROM dual;
END;