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, 1477🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...