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, 1494🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...