Migrating TSQL to PLSQL or vice versa
From TSQL to PLSQL
Apart from syntax differences, there are a host of logical differences – For e.g. TSQL procedures that use temp tables or locks have no counterpart in Oracle – there are dozens of such ‘logical’ differences.
From PLSQL to TSQL
SQL Server (TSQL) has no concept of Bitmap indexes, IOT, Table Clusters, Single Table hash clusters, non unique indexes enforcing unique constraints – any of these in use in a PLSQL stored procedure, will not have a counterpart in SQL Server.
Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.
Anuj Varma – who has written 1209 posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.
Leave a Reply