Saturday, October 21, 2017

How to install Oracle SQL Developer in a laptop and How to run a script in Oracle SQL Developer?

I am searching to find this answer in so many websites and constantly failing to connect to sql developer. Finally I found it.

Steps

1) Install jdk using this link
http://www.oracle.com/technetwork/java/javase/downloads/jdk-7-netbeans-download-432126.html
2)Install Oracle through this link. Provide a user name and password when prompting.
http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
3)Install sql developer through this link and stored the folder in C drive (You can store anywhere. But I stored in C drive.)
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
4)Provide the path in the environment variables if it does not automatically stored.
C:\Program Files\Java\jdk1.7.0_80\bin\java.exe
C:\oraclexe\app\oracle\product\11.2.0\server\bin
5) open sql developer.exe from the sql developer folder and click connect. Provide any connection name and  the username and password which u already given while installing oracle. Other parameters as default. Test the connection. Success. :)



Running Script

Open Tool- > Preferences ->Database -> worksheet-> Point the path to look for scripts

Open worksheet
Type @scriptname.sql
Run Script

No comments:

Post a Comment

GEN AI

  Stay Tuned....