Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4535👍, 0💬
Popular Posts:
Explain all parts of a deployment diagram? Package: It logically groups element of a UML model. Node...
What is a fish bone diagram ? Dr. Kaoru Ishikawa, invented the fishbone diagram. Therefore, it can b...
How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access...
What Is a CAPTION Tag/Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "capti...
Can include files be nested? The answer is yes. Include files can be nested any number of times. As ...