Data types:



	
PL/SQL is a superset of the SQL. So, it supports all the data types provided by SQL.
	
Along with this, in PL/SQL Oracle provides subtypes of data types.
	
For example, the data type NUMBER has a subtype called INTEGER.
	
These subtypes can be used in PL/SQL block to make the data type compatible with the data types of other programming languages.
	
Subtypes are simply alternative names for Oracle data types, and so, they must follow the rules of their associated data type.



	

		

			

			
Category
			
			

			
Data type
			
			

			
Subtype
			
		
		

			

			
Numerical
			
			

			
NUMBER
			
			

			
BINATY_INTEGER, DEC, DECIMAL, DOUBLEPRECISION, FLOAT, INTEGER,INT, REAL,NATURAL,NUMARIC
			
		
		

			

			
Character
			
			

			
CHAR, LONG,VARCHAR2
			
			

			
CHARCTER, VARCHAR, STRING, NCHAR
			
		
		

			

			
Date
			
			

			
DATE
			
			

			
 
			
		
		

			

			
Binary
			
			

			
RAW, LONG RAW
			
			

			
 
			
		
		

			

			
Boolean
			
			

			
BOOLEAN
			
			

			
Can have values like TRUE, FALSE and NULL
			
		
		

			

			
RowID
			
			

			
ROWID
			
			

			
Stores values of address location of each record