What are some Oracle gotchas for someone new to the platform, but not new to relational databases (MySQL, MS SQL Server, Postgres, etc.) in general.

Two examples of the kind of things I'm looking for

  1. Many relational database products handle creating an auto_increment key for you. Oracle does not, you must manually create the sequence, then create the trigger

  2. When INSERTING data via the SQL Developer interface, you have to manually commit the data

Bonus points for PHP related gotchas, as that's the platform I'll this hypothetical experienced newb will be using.

php mysql sql-server oracle-database postgresql
Edit
Report