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, 1437🔥, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
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 Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...