Developer

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!

Editor's Picks

Free Newsletters, In your Inbox