3.1 Brief Introduction to PL/SQL an

3.1 Brief Introduction to PL/SQL and
Transact-SQL
PL/SQL and Transact-SQL (TSQL for short) are two full (Turing-
Complete) programming languages at the database server side
which includeprocedures, conditionals, loops, error handlings, and
integrated SQL. PL/SQL offers subprogram overloading while
TSQL does not. In order to do a global analysis of performance
issues, AppSleuth parses the code and identifies delinquent design
patterns in semantic actions. Because these patterns include loop
and subroutine calls, the parser has to detect blocks, subprograms
possibly at different levels, and different kinds of loops (e.g.
basic, for, while, and cursor loops for PL/SQL).