Wednesday, May 7, 2008

Using SQL*Plus

Using the Command Line Interface

The command line interface is a standard feature of SQL*Plus for all platforms.
To start the command line interface:
1. If you are connecting to a remote Oracle database, make sure your SQL*Net/networking software is installed and working properly.



2. Start an MS-DOS command prompt window.
3. At the command prompt, enter:
4. SQLPLUS [username/password][@connectstring]
For Windows NT/95, the rules for interpreting arguments are:
• Arguments are delimited by white space.
• A string surrounded by double quotation marks (for example, "string") is interpreted as a single argument.
• A double quotation mark preceded by a backslash is interpreted as a literal double quotation mark.