Setting up Environment

How to open SQL *PLUS?

There are various tools which can be used to enter SQL statements.

Here I am going to tell about how to open SQL*PLUS for the first time.

After installing Oracle 10g on Windows machine follow the below steps to open SQL*PLUS:

Click on the “start” button on the desktop and in the list select the “Programs” after that another installed list will be displayed, there you need to select

Oracle- OraDB10g_home1 -> Application Development -> SQL PLUS

Once clicked on SQL PLUS it will show the log on screen where we need to enter three values i.e. User Name, Password and HOST String.

In the Host String we need to enter the name that we have assigned for TNS connectivity in the file TNSnames.ora file.

TNS file contains the machine name and port number and the SID of the database we need to specify this when we connect to the database.

Once log on to the oracle database it will display the version which is been installed and we will get a SQL Prompt where we can enter our SQL statements.

How to open iSQL plus?

iSQL Plus is a web server and application which is included in Oracle database.

The web server runs on the database on the same host.

By the help of iSQL Plus we can connect to the database and can do all operations as same in SQL*PLUS.

For opening iSQL Plus below open Internet explorer or any browser  then type the following address in the address bar http://localhost:5560/isqlplus/

Once the page is displayed you can login as oracle user and use it as like SQL*PLUS.

All this can be used as a standalone server or you can get the username, password and connection identifier from the ADMINISTRATOR.

SQL PLUS statements in the Workspace area and then we can run that by clicking on execute button. It will display the result below the input area. We can also load a script and run it but scripts are generally stored in a “.sql “extension.

This slideshow requires JavaScript.

This is an example for how the result of a SQL statement looks like when it is been executed.

So it also has an option for saving the script or the statements that we have written on the workspace area and save them as “.sql “file extension.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s