ZDNet

Store SQL*Plus variables

Oracle SQL*Plus has a very useful subparameter to the column parameter called NEW_VALUE. The NEW_VALUE directive allows you to store data retrieved from an Oracle table as a variable inside the ...
Ars Technica

Oracle PL/SQL question about global variables

What are the advantages/disadvantages of using global variables in PL/SQL packages? I have created tons of packages and stored procedures, but have never used global variables.<BR><BR>Any insight or ...
Redmond Magazine

T-SQL Smarts: Executing Sp_executesql

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...
eWeek

How to Set Variables in T-SQL

In this episode of eSpeaks, Jennifer Margles, Director of Product Management at BMC Software, discusses the transition from traditional job scheduling to the era of the autonomous enterprise. eSpeaks’ ...
Ars Technica

SQL LIKE command - passing variable to query

Ok... I'm banging my head against this SQL Command. Check it out. This works. (shortened for ease of reading)<BR><BR>SELECT [Site Table].[Site Number]<BR>From [Site ...
ZDNet

Understand Oracle COM Automation for Windows

An Oracle database server running on a Windows machine can manipulate COM Automation server objects from PL/SQL or Java stored in a database. To access a COM Automation server, a client application ...