I have a small program that uses mySQL and I am thinking to move it to Oracle. There are a few conversion issues and I appreciate your input and suggestions: 1. In mySQL there is auto_increment function but not in Oracle 9i. In my JSP sql (that uses mySQL) I could have just use insert into t_emp (id, name) value ('', 'Joe Black');
In oracle I uses sequence and the sql looks like: insert into t_emp values (emp_seq.nextval, 'Joe Black'); How could I use just 1 type of sql for both databases? 2. If I use NOW() in the DATETIME in mySQL in some INSERT statement, what should I replace with in Oracle. Actually, what is the best way to develop this type of program so that it could be deploy between mySQL(during development) and Oracle (production)? Thank you.