Collections:
Other Resources:
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
2016-10-16, 321👍, 0💬
Popular Posts:
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...