Wednesday, December 12, 2012

Oracle isql plus
iSQLPlus was first introduced with Oracle 8i to reflect the company's focus on Internet technology. iSQLPlus required that the Oracle SQL*Net drivers be installed on the client as well as the iSQLPlus program itself.
Starting with Oracle 9i, iSQLPlus was delivered as a web application. This removed the need to install client side software and enabled any client with an web browser to connect to iSQLPlus to run database queries.
Oracle decided to desupport iSQLPlus with the Oracle 11g release. Users should migrate to SQL Developer instead.

ISQL*PLUS:
  • Recognizes SQL statements and sends them to the server.
  • Oracle proprietary interface for executing SQL statements.
  • Does not allows manipulation of values in the database.
  • Uses commands for formatting data.

Oracle stopped supporting iSQL*Plus starting with Oracle11g. Oracle recommend switching to SQL Developer which can be downloaded for free from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
SQL Developer can do all of the same things iSQL*Plus can do, plus more. There are other third-party Oracle DBA/Developer tools available for purchase which I will not promote in this post, but SQL Developer should meet your needs and is easy to install/use.

Configuring I-SQL Plus
STEP 1
goto dos prompt.....  start...Run....Cmd
on command prompt type:  isqlplusctl start
after issuing the above command following prompt will displayed


Starting iSQL*Plus ...
iSQL*Plus started.

STEP 2

Open Any compatible Internet Browser.
Type the address for ISQL*PLUS

Syntax
http:// host_name:portnumber/isqlplus
to check Port number:
oracle_home=where oracle software installed.
oracle_home\install\portlist.ini

step 3
after opening the iSQL*Plus page on Expolorer.. 
LOGIN SCREEN 
ENTER username , password and the connection string 
Now isqlplus started.
you can query the database here...

1 comment: