Collections:
Declare Local Variables in Oracle
How To Declare a Local Variable in Oracle?
✍: FYIcenter.com
A local variable can be defined in the declaration part with a declaration statement, which is a variable name followed a data type identifier. Below are some examples of declaration statements:
PROCEDURE proc_var_1 AS domain VARCHAR2(80); price REAL; is_for_sale CHAR; BEGIN -- Executable statements END;
2018-11-17, 805👍, 0💬
Popular Posts:
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...