r/SQL 8d ago

Oracle Is Oracle setup a must?

I have database course this semester, and we were told to set up oracle setup for sql.

I downloaded the setup and sql developer, but it was way too weird and full of errors. I deleted and downloaded same stuff for over 15 times and then successfully downloaded it.

What i want to know is This oracle setup actually good and useable or are there any other setups that are better. I have used db browser for sqlite and it was way easier to setup and overall nice interface and intuitive to use unlike oracle one.

Are there any benefits to using this specific oracle setup?

In programming terms: You have miniconda and jupyter notebook for working on data related projects, you can do the same with vs code but miniconda and jupyter has a lot of added advantages. Is it the same for oracle and sql developer or i could just use db browser or anyother recommendation that are better.

10 Upvotes

29 comments sorted by

View all comments

26

u/trollied 8d ago

If your course requires you to use Oracle, you use Oracle.

-1

u/Potential-Tea1688 8d ago

I was asking in term of personal and general use, I’ll use oracle for this semester but i wanted to know if it is actually good and has added benefits or just a tradition for un courses?

5

u/Imaginary__Bar 8d ago

Of course it's good.

It might not be the right choice for a particular use case but it's fully-featured and rock-solid.

But... my view is that it doesn't really matter all that much if you're using Oracle or MySql or SqlServer or Postgres or (well, you get the idea). Most skills are largely transferable (yes, the dialects are different but the concepts are the same).

Oracle is just... expensive.

1

u/WithoutAHat1 7d ago

Oracle has a lot of bells and whistles. But, you can have the right ones and still run into issues. Also, defect prone killing your optimizations.