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
⇒ Execution Flow Control Statements in Oracle
⇐ Execute a Simple Stored Procedure in Oracle
2019-03-20, 1508🔥, 0💬
Popular Posts:
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...