Collections:
Data Types Supported in PL/SQL in Oracle
How Many Data Types Are Supported in Oracle?
✍: FYIcenter.com
PL/SQL supports two groups of data types:
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
2019-03-20, 801👍, 0💬
Popular Posts:
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored p...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...