Author: SSWUG Research

Community

Using Substitution Variables

You ever had a time when you wanted to run a SQL script, but the values it used had to change dynamically every time you run it? I sure have. Oracle itself (believe it or not) proposes two solutions to this task. One is to use the substitution variable marker & or the &&. What’s the difference b

Community

Fusion cooking

(Benjamin De Boe) Fusion is hot, not only in many modern kitchens, but also at Oracle, where it means the synergy between our middleware and applications offering. As you might know, the next version of our eBusiness Suite, quite appropriately referred to as Oracle Fusion Applications, is being buil

Community

User Database Query Tool

(KChandos) From time to time programmers come across users who, for whatever reason, seem to actually want to code T-SQL in order to find the information that they need. In an SQL Server environment, a common way to give them this capability is to install the SQL Query Analyzer product. Beginning wi