Basic Oracle Concepts and Programming Question:

How Many Scalar Data Types Are Supported in PL/SQL?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

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.



Previous QuestionNext Question
How Many Categories of Data Types?How To Convert Character Types to Numeric Types?