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, 1429🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...