Collections:
Use Variables in SQL Statements in Oracle
Can Variables Be Used in SQL Statements in Oracle?
✍: FYIcenter.com
Yes, you can use variables in SQL statements as part of any expressions. The tutorial script provides you some good examples:
(Connect to XE with SQL*Plus) CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL); Table created. DECLARE var_id NUMBER; var_name CHAR(10); BEGIN var_id := 29; var_name := 'Bob'; INSERT INTO student VALUES(var_id, var_name, 'Henry'); var_name := 'Joe'; INSERT INTO student VALUES(var_id+1, var_name, 'Bush'); var_name := 'Fyi'; UPDATE student SET first_name = var_name WHERE id = var_id+1; DELETE FROM student WHERE id = var_id; END; / SELECT * FROM student; ID FIRST_NAME LAST_NAME -------- ----------- ----------- 30 Fyi Bush
⇒ Variable Names Collide with Column Names in Oracle
⇐ Cannot Use DDL Statements in PL/SQL in Oracle
2018-09-24, 1887🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...