Oracle - Categories of Data Types in PL/SQL in Oracle

Categories of Data Types in PL/SQL in Oracle

Q

How Many Categories of Data Types in Oracle?

✍: FYIcenter.com

A

PL/SQL data types are grouped into 4 categories:

Scalar Data Types: A scalar data type holds a single value.
Composite Data Types: A composite data type has internal components, such as the elements of an array.
LOB Data Types: A LOB data type holds a lob locator that specify the location of a large object.
Reference Data Types: A reference data type holds a pointer that points to another data object.

⇒Understanding PL/SQL Language Basics

⇒⇒Oracle Database Tutorials

2016-10-17, 284👍, 0💬

Popular Posts:

Transaction Manageme...

Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...

CHAR(n) - Truncating...

How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...

CONVERT() - Converti...

How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...

CREATE VIEW - Creati...

How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...