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, 1419🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...