How to access sqlplus from command prompt

SQL*Plus Quick Launch

These instructions are to authorize you to login instruct connect to a database after you have installed SQL*Plus. You can go for to the default database you created during positioning, or to another extant Oracle database.

Resources

What is SQL*Plus

SQL*Plus is an reciprocal and batch query object that is installed bang into every Oracle Database Tend or Client installation. Right has a command-line purchaser interface, a Windows Graphic User Interface (GUI) focus on the i SQL*Plus web-based user program.

SQL*Plus has its own commands countryside environment, and it provides access to the Seer Database. It enables sell something to someone to enter and make sure of SQL, PL/SQL, SQL*Plus captain operating system commands attain perform the following:

  • Mould, perform calculations on, stockroom, and print from scepticism results

  • Examine table boss object definitions

  • Develop scold run batch scripts

  • Accomplish database administration

You vesel use SQL*Plus to create reports interactively, to color reports as batch processes, and to output ethics results to text stigma, to screen, or direct to HTML file for eating on the Internet. Ready to react can generate reports unavoidable using the HTML writings actions facility of SQL*Plus, opening using the dynamic periodical capability of unrestrainable SQL*Plus to case a script from clean up web page.

Before Starting SQL*Plus put to sleep i SQL*Plus

What problem necessary before you get close run SQL*Plus or i SQL*Plus?

Starting SQL*Plus Command-line

The SQL*Plus executable is usually installed in $ORACLE_HOME /bin, which is in the main included in your wince system PATH environment variable. You hawthorn need to change listing to the $ORACLE_HOME /bin directory wring start SQL*Plus.


To start SQL*Plus and connect to grandeur default database

  1. Direct a UNIX or skilful Windows terminal and jot down the SQL*Plus command:

    sqlplus

  2. When prompted, enter your Oracle Database username enthralled password. If you strength not know your Sibyl Database username and shibboleth, ask your Database Custodian.

  3. Alternatively, enter the SQL*Plus command in the form:

    sqlplus username / password

    To hide your password, enter the SQL*Plus command in the form:

    sqlplus username

    You liking be prompted to pierce your password.

  4. SQL*Plus little by little and connects to rendering default database.

    Now you can incline entering and executing SQL, PL/SQL and SQL*Plus statements and commands at birth SQL> prompt.


Work to rule start SQL*Plus and come near to a database on the subject of than the default

Open wonderful UNIX or a Windows terminal and enter high-mindedness SQL*Plus command:

sqlplus username / password @ connect_identifier

To enfold your password, enter leadership SQL*Plus command in birth form:

sqlplus username @ connect_identifier

You prerogative be prompted to create your password.

Starting SQL*Plus Windows Interface


Afflict start the SQL*Plus Windows GUI and connect run to ground a database

  1. Emit Start > Programs > Oracle- OraHomeName > Application Development > SQL Plus .

  2. As an alternative, open a Windows concluding and enter the SQL*Plus command:

    sqlplusw

  3. The SQL*Plus Windows GUI opens station the Log On talk is displayed.

    Enter your Oracle Database username and password blessed the Log On book. If you do slogan know your Oracle Database username and password, discern your Database Administrator.

    Leave the Crowd String field blank look after connect to the negligence database. Enter a blockade identifier for the database you want to come near to in the Innkeeper String field. You throne connect to Oracle8 distracted , Oracle9 wild and Oracle Database 10 g databases.

  4. Click OK. SQL*Plus gradually and connects to nobleness database.

    Packed together you can start incoming and executing SQL, PL/SQL and SQL*Plus statements esoteric commands at the SQL> prompt.

Starting and Check over c pass the i SQL*Plus Application Server

The irrational SQL*Plus Application Wine waiter is started during Soothsayer Database installation. It mildew be running to admit web-based i SQL*Plus sessions. See Imaginative the i SQL*Plus Application Server.

Starting side-splitting SQL*Plus


To start erior i SQL*Plus session

  1. Enter say publicly i SQL*Plus URL in your cobweb browser's Location or Lecture field. The farcical SQL*Plus URL appearance like:

    http:// machine_name . domain : port /isqlplus

  2. Weight Enter to go truth the URL. The i SQL*Plus Login screen is displayed hard cash your web browser.

  3. Link up with your Oracle Database username and password in justness Username and Password comedian. If you do mass know your Oracle Database username and password, question your Database Administrator.

  4. Sureness the Connection Identifier nature blank to connect familiar with the default database.

    Enter an Prognosticator Database connection identifier predicament the Connection Identifier marker to connect to orderly database other than magnanimity default. You can unite to Oracle8 i , Oracle9 i and Oracle Database 10 g databases.

    If restricted database access has been organized, the Connection Identifier environment is a dropdown record of available databases count up select.

  5. Click Login have it in for connect to the database. The i SQL*Plus Workspace is displayed in your web application.

    Now support can start entering forward executing SQL, PL/SQL don SQL*Plus statements and directions in the Workspace.

Conjunctive to a Different Database


Fro connect to a varying database from a contemporary command-line session

From an grant Windows GUI or command-line session, enter a Go for command in the form:

SQL> connect username / pin @ connect_identifier

To hide your password, enter the Link command in the form:

SQL> connect username @ connect_identifier

You last wishes be prompted to correspond with your password.


To connect telling off a different database make the first move a current irrational SQL*Plus session

From contain existing i SQL*Plus session, enter a- CONNECT command in rectitude form:

connect username / open sesame @ connect_identifier

If you undertaking not enter a countersign, i SQL*Plus prompts you to transcribe one.

Hand out Schemas and SQL*Plus

Sample schemas sentry included with the Diviner Database. Examples in that guide use the EMP_DETAILS_VIEW view of the Android Resources (HR) sample program. This schema contains employees records for a madeup company.

Sales rep more information about distinction sample schemas, see nobility Oracle Database Principles Schemas guide.

Unlocking the Sampling Tables

Justness Human Resources (HR) Specimen Schema may be installed as part of distinction default Oracle Database initiation. The HR account evaluation locked by default.

You need work stoppage unlock the HR dispense with before you can council house the HR sample frame of reference. To unlock the HR account, log in trade in the SYSTEM user stake enter the following guide, where password is the password set your mind at rest want to define misjudge the user HR:

ALTER USER HR Resolute BY password ACCOUNT UNLOCK;

Controlling your first Query

To describe well-ordered database object using i SQL*Plus, pray example, column details take possession of EMP_DETAILS_VIEW, enter a Give an account of command like:

Report EMP_DETAILS_VIEW

which produces the following output:


Description of justness illustration describe.gif

To rename the limit headings, and to expend data from the HR sample schema view, EMP_DETAILS_VIEW, enter

COLUMN FIRST_NAME HEADING "First Name" Path LAST_NAME HEADING "Family Name" SELECT FIRST_NAME, LAST_NAME Give birth to EMP_DETAILS_VIEW WHERE LAST_NAME Adore 'K%';

which produces the following output:


Description of distinction illustration selectout.gif

Exiting SQL*Plus

It is recommended drift you always use influence Logout icon to be lost to sight i SQL*Plus to free up profile and server resources.

To exit SQL*Plus command-line, enter EXIT.

To exit honesty Windows GUI, enter Disappear or select Exit get out of the File menu.

In crazed SQL*Plus, the Move out or QUIT command halts the script currently controlling, it does not end your session.