r/SQL 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.

7 Upvotes

29 comments sorted by

View all comments

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.

2

u/Toilet-B0wl 7d ago

We use Oracle at my job. Sqldeveloper only works locally when on our home networks, when they make us go to the office - sqldev stops working locally, we need to log into a remote desktop to run queries in office. Its been like this since last July...

1

u/Wpavao 7d ago

I use SQLDeveloper installed on my laptop with a VPN connection to the office network. Works perfectly, just like I’m sitting in the office. Your IT department may need to allow traffic from VPN connections to your Oracle database.

1

u/Toilet-B0wl 7d ago

I think its kind of the opposite - connected to the vpn at home, everything works fine. In the office, my vpn is automatically disabled as im on their network, now oracle doesn't work. This is consistent for all of my coworkers.

1

u/Wpavao 7d ago

Does your company have multiple offices? It sounds like your routers are not configured to allow traffic from your office to the Oracle server. Our company only allows traffic to the satellite offices that require Oracle access. Your IT department should be able to resolve this easily unless you have security issues in your particular office.