Collections:
Assign Values to Variables in Oracle
How To Assign Values to Variables in Oracle?
✍: FYIcenter.com
You can use assignment statements to assign values to variables. An assignment statement contains an assignment operator ":=", which takes the value specified on the right to the variable on left. The script below show you some examples of assignment statements:
PROCEDURE proc_var_2 AS is_done BOOLEAN; counter NUMBER := 0; message VARCHAR2(80); BEGIN is_done := FASLE; counter := counter + 1; message := 'Hello world!'; END;
⇒ Arithmetic Operations in Pl/SQL in Oracle
⇐ Initialize Variables with Default Values in Oracle
2018-08-06, 1455🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...