Triggers, Stored Procedures in MySql, MSSQL, Oracle SQL [Archive]

View Full Version : Triggers, Stored Procedures in MySql, MSSQL, Oracle SQL

vikkyhacks

October 22nd, 2012, 06:44 AM

I am planning to learn triggers and stored procedures in SQL, but every online tutorial that I find is bent towards any one of the vendors, so my question is

1. Is programming with SQL completely different in ORACLE, MySQL and MSSQL ???

2. Please send me some useful links which will help me learn, I am confused at choosing the correct online resource !!!

Lars Noodén

October 22nd, 2012, 09:40 AM

I would concentrate on MySQL and Postgresql because those will meet most or all of your needs. Oracle does also offer a free of charge download for testers and developers, IIRC.

Have you tried the manuals yet? They are short and to the point.

http://dev.mysql.com/doc/refman/5.5/en/trigger-syntax.html
http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html