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;
2018-08-06, 736👍, 0💬
Popular Posts:
How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...