Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How Many Data Types Are Supported
How Many Data Types Are Supported? - Oracle DBA FAQ - Introduction to PL/SQL
✍: 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
2007-04-25, 4778👍, 0💬
Popular Posts:
What is Windows DNA architecture? Note :- If you have worked with classic ASP this question can come...
How To Create an Add-to-My-Yahoo Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News ...
Can you tell me how to check whether a linked list is circular? Create two pointers, and set both to...
Does .NET support UNICODE and how do you know it supports? Yes .NET definitely supports UNICODE. Try...
How To Get the Last ID Assigned by MySQL? - MySQL FAQs - Managing Tables and Running Queries with PH...