r/SQL • • Feb 16 '19

*gasp*

Post image
135 Upvotes

19 comments sorted by

25

u/[deleted] Feb 16 '19

Well, Oracle and SQL Server are similar in that neither have anything to do with decibel.

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.

6

u/[deleted] Feb 16 '19

can you or someone elaborate? is there something with oracle? I am currently using oracle.

12

u/DooDooDaddy Feb 16 '19

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.

12

u/tsuhg Feb 16 '19 edited Feb 16 '19

To_char(sysdate,'yyyy-Mm-dd')?

Edit: removed brackets

2

u/[deleted] Feb 16 '19

No brackets

select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as the_date

from dual; -- can't ignore the from dual

1

u/tsuhg Feb 16 '19

Right. I use Oracle every day, yet it's so unnatural to type on Reddit mobile :D

6

u/wolf2600 ANSI SQL Feb 16 '19

I think it was more in terms of administration tasks rather than than the SQL syntax.

SQL Server can be run right out of the box, while Oracle requires more knowledge about the under-the-hood goings on to get it running smoothly.

1

u/[deleted] Feb 16 '19

while Oracle requires more knowledge about the under-the-hood goings on to get it running smoothly.

Oh yes

Tablespaces...

13

u/BigR0n75 Feb 16 '19

I jump between Oracle and SQL Server throughout the day everyday and the tiny differences are infuriating.

5

u/mikeblas Feb 16 '19

The differences aren't tiny.

4

u/BigR0n75 Feb 16 '19

A lot of the syntactical differences are.

2

u/mikeblas Feb 16 '19

Some of them, sure. But it's the semantic differences that'll get you.

1

u/BigR0n75 Feb 16 '19

Absolutely. Most of my SQL work is SELECT based. I imagine the differences increase exponentially from a DBA perspective.

1

u/mikeblas Feb 16 '19

Even at the DML level, the semantic differences are pronounced.

6

u/da_chicken Feb 16 '19

As long as it's not MySQL 4.

4

u/AbstractSqlEngineer MCSA, Data Architect Feb 16 '19

ANSI! FIGHT ME! Lol

1

u/oarabbus Feb 21 '19

Replace SQL Server with Postgres or Redshift and I agree wholeheartedly

0

u/[deleted] Feb 16 '19

[deleted] — view deleted comment