Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MqSQL to Oracle

 
Chuan Ren
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Harry Lin
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the answer of the second question

you can use sysdate to get the db's time
[ November 24, 2003: Message edited by: Harry Lin ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic