Oracle Database Interview Question:

How Many Data Types Are Supported?

Submitted by: Administrator

PL/SQL supports two groups of data types:

* SQL Data Types - All data types used for table columns.
* PL/SQL Special Data Types - Like BOOLEAN or PLS_INTEGER.

The script below shows some data type examples:

SQL> set serveroutput on;

SQL> DECLARE
2 title VARCHAR(8);
3 salary NUMBER;
4 seeking_job BOOLEAN;
5 BEGIN
6 title := 'DBA';
7 salary := 50000;
8 seeking_job := TRUE;
9 DBMS_OUTPUT.PUT_LINE('Job Title: ' || title);
10 DBMS_OUTPUT.PUT_LINE('Expected salary: '
11 || TO_CHAR(salary));
12 END;
13 /
Job Title: DBA
Expected salary: 50000
Submitted by: Administrator