Collections:
Initialize Variables with Default Values in Oracle
How To Initialize Variables with Default Values in Oracle?
✍: FYIcenter.com
There are two ways to assign default values to variables at the time of declaration:
The script below show you some examples of declaration statements with default values:
PROCEDURE proc_var_1 AS domain VARCHAR2(80) := 'fyicenter.com'; price REAL DEFAULT 999999.99; is_for_sale CHAR := 'N'; BEGIN -- Executable statements END;
⇒ Assign Values to Variables in Oracle
⇐ Declare Local Variables in Oracle
2018-08-06, 1535🔥, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...