CRITICAL SKILL 6.3

Define PL/SQL Data Types

The use of local variables within a PL/SQL program is an important knowledge point for everyone using the language. It is a basic component of each program and as such it is invaluable to gain the knowledge of what is available and how best to use it. We can now look at how we use and define variables and working storage within our PL/SQL programs.

The PL/SQL Character Set

As with all programming languages, there are characters that you use to write your programs. Each language has its own rules and restrictions when it comes to the valid characters. In the following sections, we will show you the following:

Valid characters when programming in PL/SQL

Arithmetic operators

Relational operators

Supported ...

Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.