Oracle Sequence ID increase by double

if you are using trigger to generate sequence then might happened that the trigger is called twice. So to prevent from increasing the id value here is a little trick

CREATE OR REPLACE TRIGGER TRG_ABC BEFORE INSERT ON ABC
FOR EACH ROW
BEGIN
if :NEW.ID is null
then SELECT ABC_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
end if;
END;

Oracle: use timestamp to convert string to date

http://www.xinotes.org/notes/note/422/

You can use the timestamp keyword to convert a string to Date:

select * from retail_transactions where posted_date >= timestamp '2008-12-01 00:00:00';

5 Regular Expressions Every Web Programmer Should Know

Here are 5 Regular Expressions Every Web Programmer Should Know

http://immike.net/blog/2007/04/06/5-regular-expressions-every-web-programmer-should-know/