Oracle 8 Programming: A Primer / Edition 1 by Rajshekhar Sunderraman | 9780201612585 | Paperback | Barnes & Noble
Oracle 8 Programming: A Primer / Edition 1

Oracle 8 Programming: A Primer / Edition 1

by Rajshekhar Sunderraman
     
 

ISBN-10: 0201612585

ISBN-13: 9780201612585

Pub. Date: 12/16/1999

Publisher: Pearson Education

This programming companion from Rajshekhar Sunderraman is a streamlined approach to Oracle SQL, the most prevalent database language in industry and on campus. Focusing entirely on the necessary aspects of Oracle, it is designed as a specific guide for new users of this application. Using this primer in the classroom, students will be able to complete programming

Overview

This programming companion from Rajshekhar Sunderraman is a streamlined approach to Oracle SQL, the most prevalent database language in industry and on campus. Focusing entirely on the necessary aspects of Oracle, it is designed as a specific guide for new users of this application. Using this primer in the classroom, students will be able to complete programming projects and assignments that use Oracle. These projects can be developed in a number of different programming environments (PRO*C, PL/SQL, and Oracle JDBC), thereby giving instructors flexibility and choice in these assignments.

Product Details

ISBN-13:
9780201612585
Publisher:
Pearson Education
Publication date:
12/16/1999
Edition description:
New Edition
Pages:
334
Product dimensions:
7.52(w) x 9.20(h) x 0.64(d)

Related Subjects

Table of Contents

Preface vii
The Relational Data Model
1(18)
The Relational Database
1(1)
Integrity Constraints
2(2)
Tabular View of a Relation
4(1)
Sample Databases
4(8)
Relational Algebra
12(7)
Set-Theoretic Operations
12(1)
Relation-Theoretic Operations
13(3)
Queries in Relational Algebra
16(3)
Oracle SQL
19(74)
Oracle SQL *Plus
19(10)
Entering and Exiting SQL *Plus
19(1)
Executing Commands in SQL *Plus
20(4)
Buffer Manipulation Commands
24(2)
Formatting Query Results
26(1)
Screen Capture of an SQL *Plus Session
27(2)
Creating, Dropping, and Altering Tables
29(8)
drop table
29(2)
create table
31(6)
alter table
37(1)
Inserting Rows
37(1)
Querying the Database
38(31)
Simple select Statement
38(5)
Sub-Selects
43(7)
Union
50(1)
Forall Queries
51(1)
Aggregate Functions
52(2)
The group by and having Clauses
54(2)
The Full Select Statement
56(1)
String, Number, and Date Functions
57(12)
Views
69(2)
create view
69(1)
drop view
70(1)
Modifying the Database
71(3)
insert
71(1)
update
72(1)
delete
73(1)
commit and rollback
73(1)
Sequences
74(1)
Oracle Data Dictionary
75(1)
The user_catalog Table
75(1)
The user_objects Table
75(1)
The user_tables Table
76(1)
The user_tab_columns Table
76(1)
The user_views Table
76(1)
Oracle8 Object Features
76(17)
The create type Statement
77(1)
The varying array Collection Type
78(2)
Inserting Rows
80(1)
User-Defined Methods
81(1)
Nested Tables
82(1)
Object Tables
83(1)
Inserting Rows into Nested Tables
84(1)
Querying and Accessing Data
85(3)
Exercises
88(5)
Embedded SQL
93(60)
Host Variables
93(3)
Indicator Variables
96(1)
SQL Communications Area (sqlca)
97(2)
Connecting to Oracle
99(1)
Cursors
100(3)
Mail-Order Database Application
103(14)
Customer Functions
107(5)
Process Orders
112(3)
Delete Old Orders
115(1)
Print Order Invoice
115(2)
Recursive Queries
117(3)
Error Handling
120(4)
Explicit Handling
121(2)
Implicit Handling
123(1)
Transaction Control
124(1)
Dynamic SQL
125(10)
The execute immediate Statement
125(1)
The prepare and execute using Statements
126(2)
Dynamic Select
128(7)
Pro*C++
135(18)
Compiling Pro*C++ programs
135(1)
A Simple Query Example
135(3)
Multiple Answer Query using Cursors
138(4)
Dynamic SQL Query
142(3)
Exercises
145(8)
PL/SQL
153(72)
What is PL/SQL?
153(1)
Data Types and Variables
154(2)
Program Control Statements
156(6)
null Statement
156(1)
Assignment Statement
156(1)
Conditional Statements
157(3)
Loops
160(2)
Program Structure
162(12)
Anonymous Blocks
162(1)
Procedures and Functions
163(5)
Stored Procedures and Functions
168(2)
Packages
170(4)
Triggers
174(5)
Database Access Using Cursors
179(9)
Explicit Cursors
179(4)
Parameterized Cursors
183(1)
Select for Update
184(1)
Cursor Variables
185(3)
Records
188(3)
Table-Based Records
188(1)
Cursor-Based Records
189(1)
Programmer-Defined Records
190(1)
PL/SQL Tables
191(3)
Built-In Packages
194(14)
The dbms_output Package
194(2)
The dbms_sql Package
196(12)
Error Handling
208(4)
PL/SQL Access to Oracle8 Objects
212(13)
Declaring and Initializing Objects
212(1)
Object Type Method Implementation
213(2)
Accessing Database Objects in PL/SQL
215(2)
Accessing Varying Arrays in PL/SQL
217(2)
Built-In Methods for Collection Objects
219(1)
Exercises
220(5)
Oracle JDBC
225(52)
What is JDBC?
225(1)
A Simple JDBC Program
226(1)
Developing JDBC Applications
227(4)
Loading the JDBC Drivers
228(1)
Connecting to the Database
228(1)
The Connection Object
229(2)
Nonquery SQL Statements
231(10)
Using the Statement Object
232(3)
Using the PreparedStatement Object
235(2)
Using the CallableStatement Object
237(4)
Executing SQL Queries
241(18)
The ResultSet Class
242(1)
ResultSet Methods
242(2)
An SQL Query Example
244(4)
ResultSet Metadata
248(6)
Oracle REFCURSOR Type
254(2)
Processing Multiple ResultSets
256(3)
Grade Book Application
259(7)
Function select_course
260(2)
Function add_enrolls
262(1)
Function add_scores
263(2)
Function modify_score
265(1)
Database Metadata
266(2)
Errors and Warnings
268(9)
The SQLException Class
268(1)
The SQLWarning Class
269(1)
The DataTruncation Class
270(1)
Exercises
271(6)
SQLJ: Embedded SQL in Java
277(36)
What is SQLJ?
277(1)
Simple Example
278(2)
Compiling SQLJ Programs
280(1)
Multiple Connections
281(3)
Host Variables and Expressions
284(1)
SQLJ Iterators
285(7)
named Iterators
285(5)
Positional Iterators
290(2)
Dynamic SQL using JDBC
292(2)
Calling PL/SQL from within SQLJ
294(4)
Investment Portfolio Database Application
298(15)
Exercises
310(3)
Projects
313(14)
Airline Flight Information System
314(1)
Library Database Application
315(2)
University Student Database
317(1)
Video Chain Database
318(2)
Banking Database
320(1)
BiBTeX Database
321(2)
Music Store Database
323(1)
Online Auctions Database
324(1)
Oracle Data Dictionary Browser
325(2)
Suggested Readings 327(2)
Index 329

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >