Oracle points

Alright, I have given SQL Server some nice kudos. Now it's Oracles turn.

There are two things in procedure creation that I wish SQL Server would do.

1) CREATE OR REPLACE - this handy little statement basically does a create or alter! No more looking to see if the procedure exists and then Drop / Create statements.

2 Probably my favorite Oracle coding trick so far! For variables in your procedures, you can assign a table.column data type instead of hard coding it.

Oracle -
P_SOMEVARIABLE IN SCHEMA.TABLE.COLUMN%TYPE

In SQL Server, we have to make sure the types in the procedures match up with what we code in the table. I know I'm not the only one who has made a VARCHAR (200) column and set the variable in the INSERT procedure to VARCHAR (100).

Nice work Oracle, that's two super sweet little items that actually help!