1 Connecting and Using Oracle There are many ways to access Oracle. The easiest is to use iSQL*Plus, which enables you to access Oracle from a Web browser. It requires no installation by the user. Suppose an Oracle 10g Enterprise database has been installed on the host liang.armstrong.edu with HTTP server enabled, the user can access it from a Web browser using the URL http://liang.armstrong.edu:5560/isqlplus, as shown in Figure 1.1. © Copyright Y. Daniel Liang, 2005 8 Figure 1.1 You can start iSQL*Plus from a Web browser. Enter the username (e.g., scott) and password (e.g., tiger) and click Log In to log into the database. The iSQL*Plus user interface is shown in Figure 1.2. Figure 1.2 You can enter SQL statements, save a SQL script, and load SQL script from iSQL*Plus. Enter the following SQL statements in the Enter Statement text box and click the Execute button. The execution result is displayed on the work screen, as shown in Figure 1.3. create table State( name varchar(15) not null, capital varchar(25), population integer); insert into State values ('Georgia', 'Atlanta', 8383915); insert into State values ('New York', 'Albany', 19011378); select * from State; commit; The commit statement ends the current transaction and...
Website: cs.armstrong.edu | Filesize: 267kb
No of Page(s): 6
Download Oracle Tutorial - Programming.pdf
No comments:
Post a Comment