Learn PL/SQL: Declaring Variables, Named vs Anonymous Blocks

This is part 2 of a series on learning PL/SQL. If you are new to PL/SQL, you should read part 1 first.

Also, check out the Article Index.

Declaring Variables


We've

spoken about the declaration section of a PL/SQL block. The declaration

section is the first section of a block. In the declaration section you

will identify a variable (give it a name), declare the datatype,

optionally declare it as a constant and optionally assign it a value.

I'm

going to discuss PL/SQL datatypes in detail in a future article. For

now, don't worry so much about the data types as about the format of

the declaration.

Read the rest of this post!