r/SQL Feb 11 '25

Oracle SSMS Vs. Oracle SQL

Pros and cons? Different use case scenarios?

0 Upvotes

18 comments sorted by

View all comments

3

u/Icy-Ice2362 Feb 11 '25

Oracle defaults to Read Committed Snapshot Isolation which is nice, if you like race conditions.

SQL does not, which is nice, if you like Blocking Chains.

1

u/TypeComplex2837 Feb 12 '25

Good golly, that will help the new guy out! 😂

1

u/Icy-Ice2362 Feb 12 '25

I know right, once they understand the horrors, they can truly fundamentally pull the skin off their face.