Oracle PL/SQL - PL SQL Data Type

PL SQL Data Type tutorial

Introduction

The tutorial for PL SQL Data Type are organized in the following chapters.

PL SQL Data Type

PL/SQL Data Types Topic:2

Float and Double type

CHAR and VARCHAR2 Variables Size Topic:14

BOOLEAN Data Type Topic:2

PLS_INTEGER and BINARY_INTEGER Data Types Topic:4

Unconstrained Subtypes Topic:4

Collection Types Topic:5

Associative Arrays Topic:7

Varrays (Variable-Size Arrays) Topic:5

Nested Tables Topic:9

Collection Methods

DELETE Collection Method Topic:2

TRIM Collection Method

EXTEND Collection Method

EXISTS Collection Method

FIRST and LAST Methods for Associative Array Topic:2

FIRST and LAST Methods for Varray

FIRST and LAST Methods for Nested Table

COUNT Method for Varray

COUNT Method for Nested Table

LIMIT Collection Method

PRIOR and NEXT Collection Methods Topic:2

RECORD Types Topic:19

%ROWTYPE Attribute Topic:9

NUMBER type Topic:7

DATE data type in PL/SQL Topic:8

TIMESTAMP Type Topic:2

Large objects (CLOB, BLOB) Topic:3

BFILE type Topic:2

Object types Topic:5