SQL Command-Line Interface

The SQL*Plus command-line interface requires that you have an account on the server or that you install Oracle client software on your local machine. The command-line tool requires a thick-client connection to build a socket between a client and server. The interactive SQL*Plus interface is provided by the Oracle client software.

You can access the SQL*Plus application directly when you are working on the same machine as the Oracle database. If you are working on a Linux machine, you will need to put the $ORACLE_HOME/bin directory in your environment path and set several other environment variables. You will find the instructions for setting the Oracle Database XE Client environment variables in the Oracle Database ...

Get Oracle Database 10g Express Edition PHP Web Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.