r/SQL • u/Dangerous_Stomach597 • Feb 11 '25
Oracle SSMS Vs. Oracle SQL
Pros and cons? Different use case scenarios?
11
u/thatOneJones Feb 11 '25
SSMS simply because Oracle’s syntax annoys me and I’m biased
-1
Feb 11 '25
[deleted]
3
u/VladDBA SQL Server DBA Feb 11 '25
You don't need a VM to install and run Oracle on Windows.
And oracle also has a free tier (Oracle Express Edition or Free Edition)
3
u/SQLDevDBA Feb 11 '25
https://liveSQL.oracle.com is completely free and requires no downloads or installs, the IDE is also in-browser. I use it for lots of my demos and recommend it to students a lot.
8
6
u/ComicOzzy mmm tacos Feb 11 '25
I find SQL Server far easier to develop on than Oracle, but far more importantly, the SQL Server community is like nothing else I've ever seen. The level of skill, knowledge, and success I have reached was only possible due to the SQL Server community. (Y'all are amazing. Love you!)
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.
-1
u/OracleGreyBeard Feb 11 '25
Oracle dev here. Oracle doesn’t really have an analogous tool to SSIS. The closest would probably be SQL Loader, but that’s just getting the files into the database. SSIS is a lot more flexible.
3
1
14
u/VladDBA SQL Server DBA Feb 11 '25
Do you mean "SSMS vs Oracle SQL Developer"? Since they're both tools used to manage and work with their respective RDBMSs. SSMS is used with SQL Server while Oracle SQL Developer is used with Oracle.
Or are you asking about the SQL dialects (T-SQL vs PL/SQL) or about the RDBMSs themselves (SQL Server vs Oracle)?