Re: oracle v SS
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 7 Nov 2019 17:24:33 -0500
Message-ID: <e9779c50-4551-ad24-a6e1-35edeacc7bde_at_gmail.com>
Date: Thu, 7 Nov 2019 17:24:33 -0500
Message-ID: <e9779c50-4551-ad24-a6e1-35edeacc7bde_at_gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 07 2019 - 23:24:33 CET