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, 4731👍, 0💬
Popular Posts:
How To Create an Add-to-Bloglines Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News...
How do we get the current culture of the environment in windows and ASP.NET? “CultureInfo.CurrentCul. ..
What is the result of using Option Explicit? When writing your C program, you can include files in t...
What Is a CAPTION Tag/Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "capti...
How was XML handled during COM times? During COM it was done by using MSXML 4.0. So old languages li...