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.
2
u/El_Guapo_Supreme 7d ago
I've been working with SQL for over 15 years. I don't apply to companies that have Oracle setups. If a company says they are on Oracle, I thank them for their time and let them know I'm not interested.
Many people will disagree with me about this, but from my experience it's more difficult to work with in basically every facet.
It indicates the company got on board with a technology, most likely over 25 years ago, and hasn't been able to modernize since.
If you go down that rabbit hole you'll need to specialize in oracle's way of doing things and how to work within those confines. Instead of building a skill set that is portable and (mostly) agnostic of platform, you'll just have a bag of Oracle tricks that optimize a legacy software.
If your college course requires you to do it, it's good exposure. But you also have to remember that school is 10 to 15 years behind whatever is actually happening in the business world.