How Many Scalar Data Types Are Supported in PL/SQL

Home > Oracle > PL/SQL

Q

How Many Scalar Data Types Are Supported in PL/SQL? - Oracle DBA FAQ - Understanding PL/SQL Language Basics

✍: FYIcenter.com

A

PL/SQL supports many scalar data types divided into 4 groups:

Numeric Types: BINARY_DOUBLE, BINARY_FLOAT, BINARY_INTEGER, DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NATURAL, NATURALN, NUMBER, NUMERIC, PLS_INTEGER, POSITIVE, POSITIVEN, REAL, SIGNTYPE, SMALLINT.
Character Types: CHAR, CHARACTER, LONG, LONG RAW, NCHAR, NVARCHAR2, RAW, ROWID, STRING, UROWID, VARCHAR, VARCHAR2.
Boolean Types: BOOLEAN.
Date Types: DATE, TIMESTAMP, TIMESTAMP WITH TIMEZONE, TIMESTAMP WITH LOCAL TIMEZONE, INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND.

2007-04-30, 4960👍, 0💬

How Many Categories of Data Types
How Many Categories of Data Types? - Oracle DBA FAQ - Understanding PL/SQL Language Basics 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 arra... 2007-04-30, 5713👍, 0💬

How To Convert Character Types to Numeric Types
How To Convert Character Types to Numeric Types? - Oracle DBA FAQ - Understanding PL/SQL Language Basics You can convert character types to numeric types in two ways: Explicitly by using TO_NUMBER() function. Implicitly by putting character data in a numeric operation. The sample script below shows ... 2007-04-30, 5564👍, 0💬

What Are the Logical Operations
What Are the Logical Operations? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL supports 3 logical operations as shown in the following sample script: PROCEDURE proc_comparison AS x BOOLEAN := TRUE; y BOOLEAN := FALSE; res BOOLEAN; BEGIN res = x AND y; res = x OR y; res = NOT x; -- m... 2007-04-30, 5398👍, 0💬

How To Assign Values to Variables
How To Assign Values to Variables? - Oracle DBA FAQ - Understanding PL/SQL Language Basics You can use assignment statements to assign values to variables. An assignment statement contains an assignment operator ":=", which takes the value specified on the right to the variable on left. The script b... 2007-04-30, 5269👍, 0💬

How To Use "FOR" Statements
How To Use "FOR" Statements? - Oracle DBA FAQ - Understanding PL/SQL Language Basics If you have a block of codes to be executed repeatedly over a range of values, you can use the "FOR ... LOOP" statement. Here is a sample script on FOR statements: DECLARE total NUMBER := 0; BEGIN FOR i IN 1..10 LOO... 2007-04-29, 5161👍, 0💬

What Are the Arithmetic Operations
What Are the Arithmetic Operations? - Oracle DBA FAQ - Understanding PL/SQL Language Basics There are 4 basic arithmetic operations on numeric values as shown in the following sample script: PROCEDURE proc_arithmetic AS addition NUMBER; subtraction NUMBER; multiplication NUMBER; division NUMBER; BEG... 2007-04-30, 5149👍, 0💬

What Are the Numeric Comparison Operations
What Are the Numeric Comparison Operations? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL supports 6 basic numeric comparison operations as shown in the following sample script: PROCEDURE proc_comparison AS res BOOLEAN; BEGIN res := 1 = 2; res := 1 2; res := 1 = 2; res := 1 2; -- mo... 2007-04-30, 5118👍, 0💬

What Are the Execution Control Statements
What Are the Execution Control Statements? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements... 2007-04-30, 5033👍, 0💬

How To Use "WHILE" Statements
How To Use "WHILE" Statements? - Oracle DBA FAQ - Understanding PL/SQL Language Basics If you have a block of codes to be executed repeatedly based a condition, you can use the "WHILE ... LOOP" statement. Here is a sample script on WHILE statements: DECLARE total NUMBER; BEGIN total := 0; WHILE tota... 2007-04-29, 5003👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.