Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Can Variables Be Used in SQL Statements
Can Variables Be Used in SQL Statements? - Oracle DBA FAQ - Working with Database Objects in PL/SQL
✍: 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
2007-04-28, 4567👍, 0💬
Popular Posts:
If we have the following in a Java code: String s="abc"; String s2="abc"; Then what will be output o...
Can event’s have access modifiers ? Event’s are always public as they are meant to serve every one r...
.NET INTERVIEW QUESTIONS - What is COM ? Microsoft’s COM is a technology for component software deve...
How To Control Table Widths? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells Usually, b...
What Is C Language? The C programming language is a standardized programming language developed in t...