Welcome

PL SQL Tutorial

PL SQL Variables

In PL/SQL a every for string literal,constant or number,date,time etc., memory will be allocated, Name is assigned to this memory location is called as a Variable. PL-SQL is statically typed programming language. every variables must be declared before its use. Pl/SQL variables are case-insensitive. Every variable must follow following guidlines

1. Variable Name should start with Alphabet, can contain upto 30 characters length
2. Multi-word variable can be seperated by underscore character
3. Variable can contain numbers.
4. Variables can contain $(dollar sign) and Hash(#) character

PL/SQL Datatypes

• SQL DATA TYPES
• BOOLEAN
• PLS_INTEGER
• REF CURSOR

BOOLEAN Data Type

    BOOLEAN data type represents logical values.values are TRUE,FALSE and NULL.