Oracle Reference

Administration
Backup/Recovery
PL/SQL
Scripts
SQL and Object Reference
SQL*Plus
Tuning
Utilities
White Papers
FAQ

O/S and Other Reference

ASP With Oracle
Unix
Windows NT

DBSTAR - WebAdmin

WebAdmin

MyDBSTAR

Login

Search

Anonymous PL/SQL block - Example of processing a cursor

Anonymous PL/SQL block - using SQL*Plus defined variables

Cursor- Example of a cursor reading records from a table and then inserting into another

How to see open cursors

Procedure - Skeleton of a procedure

utl_file - Example of writing to utl_file

varray - Example of storing 10 records from a table into a varray in Oracle8