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, 1577🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...