Has Oracle always been this naff?

[TheFaQQer]

What's wrong with TOAD?

It's not free, and doesn't do what Raptor does.

[doodab]

No most people will already have a Java runtime installed and you really don't want multiple Java runtimes on computer.

Well, you don't want multiples in your system path really, but multiple JDKs is quite normal for a java dev, I usually have at least 5, 6 and 7 on the go, sometimes multiple minor versions too.

[TheFaQQer]

Toad for Querying yes.

Still have to set up a stupid massive footprint on your computer to use Oracle. I mean a TNSNAMES.ORA file, Oracle Client and the services needs to be running to get access to a remote database. WTF is that all about?

You don't need any of those things for SQL Developer. You just need to install the one product and either point it to an existing Java install or install it with the product.

SQL developer takes up about 100MB of disk space, though.

[TheFaQQer]

I think it was 8i that bought the "universal installer" java thing in.

Think so. The one thing that Oracle have been consistently bad at is writing an installer. Seems to be getting better now though.

[doodab]

I think suity's problem might be that he's installed it somewhere that needs admin permissions to update the sqldeveloper.conf so he probably needs to run it as admin.

[TheFaQQer]

I think suity's problem might be that he's installed it somewhere that needs admin permissions to update the sqldeveloper.conf so he probably needs to run it as admin.

I don't think that even begins to cover the list of Suity's problems.

I wonder if the playroom has padded walls.

[d000hg]

Toad for Querying yes.

Still have to set up a stupid massive footprint on your computer to use Oracle. I mean a TNSNAMES.ORA file, Oracle Client and the services needs to be running to get access to a remote database. WTF is that all about?

I cannot remember the tool, but I've definitely used a standalone client that lets you connect to a remote Oracle DB without any extra things to install/configure on your local box. It let you do queries, edit/compile stored procedures and so on.

Now it's annoying me I can't remember the name

[Spacecadet]

I cannot remember the tool, but I've definitely used a standalone client that lets you connect to a remote Oracle DB without any extra things to install/configure on your local box. It let you do queries, edit/compile stored procedures and so on.

Now it's annoying me I can't remember the name

Will it connect to other databases too using ODBC?

[milanbenes]

Well, you don't want multiples in your system path really, but multiple JDKs is quite normal for a java dev, I usually have at least 5, 6 and 7 on the go, sometimes multiple minor versions too.

exackery

we've got .net systems with different parts of the runtime working against different jdk versions

Milan.

[TheFaQQer]

I cannot remember the tool, but I've definitely used a standalone client that lets you connect to a remote Oracle DB without any extra things to install/configure on your local box. It let you do queries, edit/compile stored procedures and so on.

Now it's annoying me I can't remember the name

SQL Developer - which Suity can't get to work.

You can also do database comparisons, data modelling, testing, session monitoring, debugging, DBA tasks....

Will it connect to other databases too using ODBC?

Not that I can see, but it will connect via JDBC, LDAP, TNS or providing the connection details to the Oracle database (host, port and SID/service name)