Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...
To practice with the examples in this chapter, you will need to use the sample data library provided with the SQL Query Window. Submit the following statement in the PROGRAM EDITOR window to assign ...
You can implement automatic lookup for any column in a table that can be accessed from the SQL Query window. An action automatically occurs when that column and an operator is selected from the Where ...