Oracle Tutorial - Programming

Supplement IV.C: Tutorial for Oracle For Introduction to Java Programming By Y. Daniel Liang This supplement covers the following topics: • Connecting and Using Oracle • Creating User Accounts • Accessing Oracle using Java NOTE: Please use Oracle 10.g or high with this tutorial. 0 Introduction Oracle 10g Enterprise runs on Windows 2000, Linux and Solaris. It can support multiple users concurrently on the network. Students can access an Oracle 10g from a Web browser without installing any Oracle software.

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