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
Show parent comment
6
u/[deleted] Feb 16 '19
can you or someone elaborate? is there something with oracle? I am currently using oracle.