You are here

Oracle Client + Oracle SQL Developer

6 posts / 0 new
Last post
JPedrosa
Offline
Last seen: 14 years 8 months ago
Joined: 2006-10-17 07:24
Oracle Client + Oracle SQL Developer

hi everyone.
i wrote this request ... with few hope Sad
what i really need is a way to become really indipendent.

i use oracle on a daily base and many times at a client site, there are special policies about conecting my laptop to their network, so i got limited to tools i can put the server, and access them with remote desktop.

the oracle cliet would be wonderfull, because them i could use, sqplus, but the SQL Developer is a nice app, running on JAVA that allows some better interface than the good old SQLPLUS.

best regards,
JP

sblandin
Offline
Last seen: 7 years 7 months ago
Joined: 2006-02-16 05:12
As far as I know

SQL developer is somehow portable, but to use it you have to install JDK (not just the runtime) on the target machine. However as long as it know the absolute path to JDK you can run it from everywhere. I have tried it and it works well also from an USB drive, but I have abandoned the idea since I use it always from the same machine.
Another good product mentioned on this site is SquirrelSQL. It needs a Java Runtime Environment to run and it can connect to any JDBC compliant database. However it seems to me that it hasn't too much feature for PL/SQL.

Bye

sblandin

RossGoodman
Offline
Last seen: 1 year 7 months ago
Joined: 2005-12-19 12:51
I use "Data Studio" which is

I use "Data Studio" which is quite a good IDE for most DB platforms.
You can get it here : http://www.aquafold.com/

JPedrosa
Offline
Last seen: 14 years 8 months ago
Joined: 2006-10-17 07:24
yes i understand that sql

yes i understand that sql devolper is portable, and some others, but not the oracle client...

many times one of the limitations i have is that the laptop/desktop that the client let's me use, does not have anything.
so i use remote desktop to the Oracle server, and use SQLPLUS Sad

anyway, if oraclient is not portable, maybe i will start running sql delevoper or any other that does not required installation on the server it self and keep using the remote desktop Sad

regards,
JP

sblandin
Offline
Last seen: 7 years 7 months ago
Joined: 2006-02-16 05:12
I am not sure

But SQL Developer uses JDBC drivers (and it comes packaged with them) so you should not need Oracle Client suite.
I'm not an expert but Oracle Client is a collection of driver and some utility that require integration with the underlyng OS (at least for the drivers) so I doubt that they can be made portable.
Your client has a strange sense of security: He doesn't allow you to install anything on your PC but it gives you acces with the remote desktop...

Bye

JPedrosa
Offline
Last seen: 14 years 8 months ago
Joined: 2006-10-17 07:24
yes i know the sense of

yes i know the sense of security is strange.

well not quite, at least they reduce the virus possibility, and those things. i have full access to the server, and i should but strange machines on the network, no.

about the sql developer, i saw no JDBC, but i'll check, i never used JDBC always the regular conection.

thanks.
JP

Topic locked