Follow this blog:
RSS
Email Alert

Software Engineer

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!

Get IT Tips, news, and reviews delivered directly to your inbox by subscribing to TechRepublic’s free newsletters.