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.

ADS