This content has been marked as final. Show 4 replies
It depends on how good your developers are at creating User-Defined Functions (haha - bad DBA joke there)
There is a universal standard of SQL - last updated in 2011 - which is universal across all of the major RDBMS.
Each distribution, however, has an extension of SQL to allow for procedural work which the universal standard does not provide.
Oracle has PL/SQL, SQL Server/Sybase has Transact-SQL, DB2 has SQL PL.
Certain boffins - such as Steve Feuerstein - state that in order for you to be a GREAT developer, you shouldn't use ANY PL/SQL but use purely SQL.
Not sure how many people can genuinely do that, though.