Using Shared Variables

A shared variable can be used in SQL statements in places where we expect or allow a constant. Remember that shared variables are preceded by a colon when so used. Here is an example in which we use the variables of "System Aspects of SQL" Example 1, as components

Queries in PSM

There are many ways that select-from-where queries are used in PSM. 1. Subqueries can be used in conditions, or in general, any place a subquery is legal in SQL. We saw two examples of subqueries in lines (3) and (6) of "Branching Statements" Figure 2, for instance.

Page 3 of 3 Previous 1 2 3 Next