How Many Data Types Are Supported?
SQL tutorial | Interview questions | Oracle :: Interview questions :: Introduction to PL/SQL | Interview questions
Page 1 of 1
How Many Data Types Are Supported?
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(;
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: ' || TO_CHAR(salary));
11 END;
12 /
Job Title: DBA
Expected salary: 50000
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(;
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: ' || TO_CHAR(salary));
11 END;
12 /
Job Title: DBA
Expected salary: 50000
Similar topics
» What Are the ANSI Data Types Supported in Oracle?
» How Many Types of Tables Supported by Oracle?
» What Are the Types PL/SQL Code Blocks?
» How Many Categories of Data Types?
» What Are the Oracle Built-in Data Types?
» How Many Types of Tables Supported by Oracle?
» What Are the Types PL/SQL Code Blocks?
» How Many Categories of Data Types?
» What Are the Oracle Built-in Data Types?
SQL tutorial | Interview questions | Oracle :: Interview questions :: Introduction to PL/SQL | Interview questions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
Sun Jan 31, 2010 12:35 am by Micheal
» Accessing tables of other users in SQL
Sun Jan 31, 2010 12:34 am by Micheal
» Grouping commands in SQL
Sun Jan 31, 2010 12:32 am by Micheal
» Operations on Result Sets in SQL
Sun Jan 31, 2010 12:31 am by Micheal
» Subqueries in SQL
Sun Jan 31, 2010 12:30 am by Micheal
» Joining Relations in SQL
Sun Jan 31, 2010 12:28 am by Micheal
» Delete comand in SQL
Sun Jan 31, 2010 12:27 am by Micheal
» Update command in SQL
Sun Jan 31, 2010 12:26 am by Micheal
» Insert command in SQL
Sun Jan 31, 2010 12:23 am by Micheal