I have been extensively working with the Oracle Database over the last couple of weeks. I thought I would share some of my experiences. The version I've been playing around isn't the newest, but, it roughly compares with the versions of MySQL and SQL Servers when I was learning databases. There is quite an interesting comparison of the capabilities.
No Auto-Increment
There is no syntax to define an auto increment when defining a new or modifying an existing table. One has to create a trigger to create an auto-increment on a column.
Inconsistent/Unintuitive Syntax
Some of the syntaxes are inconsistent and therefore inconsistent. Let's take ALTAER TABLE construct as our example. To add a new column, we have ADD column_name column_type whilst to delete a column DELETE COLUMN column_name.
|
1 |
ALTER TABLE ADD NEW_COLUMN varchar(20) |
|
1 |
ALTER TABLE DELETE COLUMN NEW_COLUMN |
PLSQL is Crap
Don't ever try to run more than 150 update queries at once, the thing just gonna crash.