Database Reference
In-Depth Information
This example placed the username, password, and Oracle database net-
work name (SID) in the source code. This is not necessarily a good idea in a
commercial environment from a security perspective. Anyone can view the
source code of an HTML document and retrieve information. It would be
better to modify the HTML in your document so that the user is required
to enter a username and password. Additionally, secure socket layers (SSL)
can be used to encrypt data traveling between a Web browser and the server.
8.4.2
iSQL*Plus versus SQL*Plus
The main features of iSQL*Plus are similar to the features of SQL*Plus or
SQL*Plus Worksheet:
Enter SQL commands in a box and click the Execute button to dis-
play the results. Results can be displayed below the box or in a new
browser window.
Adjust environment settings by clicking the Preferences button, using
a series of radio buttons and boxes to modify settings such as HEAD-
ING, RECSEP, and so on.
Use variables just like SQL*Plus, except you cannot use the ACCEPT
or PROMPT commands to prompt for values. iSQL*Plus displays its
own prompt.
Note:
iSQL*Plus allows prompts for input values.
Review and retrieve previous SQL commands by clicking the History
button, much like SQL*Plus Worksheet.
8.4.3
Troubleshooting iSQL*Plus
If there are problems running iSQL*Plus, configuration settings and other
things can be checked on the server.
Check that the port number is the default 7778 value in the file
HTTPD.CONF in the $ORACLE_HOME/Apache/Apache/conf
directory.
