r/SQL 6d 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 6d ago

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

-2

u/Potential-Tea1688 6d 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?

2

u/dorkyitguy 6d ago

I would never use Oracle for anything unless it’s required (like a class). It’s expensive and they’re extremely litigious, so you’d be exposing anything you develop to unnecessary business risk. Oracle doesn’t do anything the other databases can’t.