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, 1551🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
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 set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...