Re: oracle v SS

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Noveljic Nenad <nenad.noveljic@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 7 Nov 2019 17:24:33 -0500

And PL/SQL is my greatest gripe against SQL Server. DB2 can execute PL/SQL natively. Even humble PostgreSQL which is begrudgingly imitating Oracle in many features has an interpreter which is almost identical to PL/SQL. Yet SS, for some reason, stubbornly refuses to implement PL/SQL as an alternative, despite PL/SQL being far superior to  T-SQL. I can only pray that Satya Nadella learns the way of the Force and decides to implement PL/SQL.

On 11/7/19 4:41 PM, Noveljic Nenad wrote:

- PL/SQL is much more sophisticated than TSQL, which might be relevant if you 
plan to store your application logic in the database. Actually, TSQL doesn't 
scale well when the same code is concurrently executed by multiple sessions.

Mladen Gogala
Database Consultant
Tel: (347) 321-1217


Other related posts: