Helping PHP developers migrate from MySQL to Oracle
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 […]
We’ve almost made it through the first day of the PHP conference in Germany. The conference is well organised and a smashing success. Thanks to everyone who has stopped by the booth and said hello!
We’ve noted some points that people are generally surprised to learn when talking to us:
Oracle XE is free to develop on, […]
My previous article on implementing incremental RMAN backups on XE had some problems:
I failed to set a recovery window so that RMAN could accurately determine which backups were okay to delete
I referred to my tag as whole_db_cpy in my copy and whole_db_copy in my incremental backup
This combination led to a very small database taking up […]
Oracle as such does not have an auto increment field type. You can however emulate the auto increment field type using a trigger and you can also retrieve the auto incremented value back from an insert statement. This article will show you all you need to emulate auto increment type fields in Oracle.
