Oracle8i SQLJ Developer's Guide and Reference Release 3 (8.1.7) Part Number A83723-01 |
Library | Service | Contents | Index

# 3
Basic Language Features

This chapter discusses basic SQLJ language features and constructs that you use in coding your application.

SQLJ statements always begin with a `#sql` token and can be broken into two main categories: 1) declarations, used for creating Java classes for iterators (similar to JDBC result sets) or connection contexts (designed to help you strongly type your connections according to the sets of SQL entities being used); and 2) executable statements, used to execute embedded SQL operations.

For more advanced topics, see Chapter 7, "Advanced Language Features".

This chapter discusses the following topics.

- Overview of SQLJ Declarations

- Overview of SQLJ Executable Statements

- Java Host Expressions, Context Expressions, and Result Expressions

- Single-Row Query Results--SELECT INTO Statements

- Multi-Row Query Results--SQLJ Iterators

- Assignment Statements (SET)

- Stored Procedure and Function Calls

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index