Preface

Oracle AI Database PL/SQL Language Reference describes and explains how to use PL/SQL, the Oracle procedural extension of SQL.

Topics

• Audience

• Related Documents

• Conventions

• Syntax Descriptions

Audience

Oracle AI Database PL/SQL Language Reference is intended for anyone who is developing PL/SQL-based applications for either an Oracle AI Database or an Oracle TimesTen In-Memory Database, including:

• Programmers

• Systems analysts

• Project managers

• Database administrators

To use this document effectively, you need a working knowledge of:

• Oracle AI Database

• Structured Query Language (SQL)

• Basic programming concepts such as IF-THEN statements, loops, procedures, and functions

Related Documents

For more information, see these documents in the Oracle AI Database documentation set:

• Oracle AI Database SQL Language Reference

• Oracle AI Database PL/SQL Packages and Types Reference

• Oracle AI Database JSON Developer’s Guide

• Oracle AI Database SODA for PL/SQL Developer's Guide

• Oracle AI Database Development Guide

• Oracle AI Database Administrator’s Guide

• Oracle AI Database SecureFiles and Large Objects Developer's Guide

• Oracle AI Database Object-Relational Developer's Guide

• Oracle AI Database Concepts

• Oracle AI Database Performance Tuning GuideHi

• Oracle AI Database Sample Schemas

See Also:

https://www.oracle.com/database/technologies/appdev/plsql.html

Conventions

This document uses these text conventions:

Convention	Meaning
boldface	Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic	Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace	Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.
{A|B|C}	Choose either A, B, or C.

Also:

• *_view means all static data dictionary views whose names end with view. For example, *_ERRORS means ALL_ERRORS, DBA_ERRORS, and USER_ERRORS. For more information about any static data dictionary view, or about static dictionary views in general, see Oracle AI Database Reference.

• Table names not qualified with schema names are in the sample schema HR. For information about the sample schemas, see Oracle AI Database Sample Schemas.

Syntax Descriptions

Syntax descriptions are provided in this book for various SQL, PL/SQL, or other command-line constructs in graphic form or Backus Naur Form (BNF). See Oracle AI Database SQL Language Reference for information about how to interpret these descriptions.