tags:

views:

537

answers:

3

Hi just installed oracle 11g and tried to start the "Oracle SQL developer" so as to start writing queries. Its asking me

Enter the full pathname for the java.exe file .

Where do i find this. I did a global search for java.exe and am sure did not got some oracle related pdf files. Also my Oracle is installed out of users/vas

+2  A: 

If you don't have java installed, you need to install it.

https://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/ViewProductDetail-Start?ProductRef=jre-6u20-oth-JPR@CDS-CDS_Developer

Brian Roach
thanks Brian.but what is the connection betweeen oracle SQL and java?
vas
Oracle SQL Developer is a desktop application written in Java, so you need the Java Runtime Environment (JRE) to use it.
Brian Roach
It's not a database server ... it's a nice desktop front end for accessing the Oracle server, doing queries, etc. (See azp74's comment below ... I don't think I understood what you were asking)
Brian Roach
No, it won't be the same as a SQL Server tool, because it's an Oracle tool.
azp74
AFAIK SQL Developer needs Java Development Kit (JDK), it won't work with runtime (JRE) only.Downloads:http://java.sun.com/javase/downloads/widget/jdk6.jsp
Juraj
+1  A: 

If you have Java installed, java.exe will be in the bin directory. If you can't find it, download and install Java, then use the install path + "\bin".

Kaleb Brasee
thanks for the quick answer . what is the connection betweeen oracle SQL and java?
vas
+1  A: 

If you don't want to install Java or you just want to get started writing queries quickly, then use SQL*Plus, which is the command line too.

It's not pretty, but will get you started quickly and there is Oracle documentation on it.

azp74
Often I think sticking a fork in my eye would be better than using SQL*Plus.
Brian Roach