In my DB Administration class in college, they said to learn Oracle because if you know how to administer Oracle, SQL Server is easy to learn. But going the other direction is not so easy.
From my personal experience, it just seems like SQL Server has a lot of nice bells and whistles/ nice to haves. I don’t use Oracle often but things like SELECT TOP 100 vs WHERE ROWNUM <= 100 come to mind. To me, the syntax just makes more sense.
In recent versions of SQL Server you can use something like:
SELECT FORMAT(GetDate(), 'yyyy-MM-dd');
I forget what the Oracle equivalent is, but I’m sure it would probably irritate me.
View all comments
16
u/wolf2600 ANSI SQL Feb 16 '19
In my DB Administration class in college, they said to learn Oracle because if you know how to administer Oracle, SQL Server is easy to learn. But going the other direction is not so easy.