Helping PHP developers migrate from MySQL to Oracle
The MySQL enum column type is useful for enforcing constraints on your text data columns. We’ll look at how to emulate this functionality in Oracle using standard SQL constraints. As an example, let’s look at a simple MySQL comments table.
CREATE TABLE comments(
comment_text text,
comment_type ENUM (’spam’, […]
When porting an application from MySQL to Oracle you have to be aware of the different ways that dates and times are handled.
In this post we’ll be looking at making porting easier by providing a set of date and time functions ported to Oracle in order to reduce the number of SQL queries to modify.
Take […]
One of the major items to note when converting an application from using MySQL to Oracle is the way in which column names are handled. Generally MySQL returns column names lowercased and Oracle generally returns column names uppercased.
Notice the keyword in both cases being ‘generally’. As with most things to do with MySQL and Oracle everything is not always as easy as it seems.
