Oracle SQL Jumpstart with Examples- P5: Review "As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single. | 170 Using iSQL Plus Figure Your Customized Report Running Web Page. cuted within the browser HTML page both of which are stored on the server running the HTTP server process. Figure The CDREPORT Script Was Run and Displayed. Please purchase PDF Split-Merge on to remove this watermark. Using iSQL Plus 171 This example placed the username password and Oracle database network 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. 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 display 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 HEADING 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 1 Ji U iSQL Plus allows prompts for input values. Review and retrieve previous SQL commands by clicking the History button much like SQL Plus Worksheet. 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 in the ORACLE_HOME Apache Apache conf directory. Chapter 8 Please purchase PDF Split-Merge on to remove this watermark. 172 Using
