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, 1465🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...