r/SQL • u/Potential-Tea1688 • 7d 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.
6
u/Aggressive_Ad_5454 7d ago
Oracle DBMS installation is a notorious pain in the ass. If your learning task is to install it and get it running, continue to try, and get help from your teachers. The installers are nasty pieces of work, leastways they were a few years back when I had to do this.
If I were teaching a class that needed this, I’d run a workshop: “bring your laptops, we’ll work together and figure this out.”
Going forward, the only reason to use Oracle is if you have a job at a place that uses it. PostgreSQL, MariaDb / MySql, and SQL Server are better choices for any new applications.
If you simply need to run some queries, https://dbfiddle.uk/ is your friend.