CHAPTER 9PL/SQL
The extended programming language for SQL Server is Transact-SQL (T-SQL). For Oracle, the programming language is PL/SQL. These programming languages provide additional capabilities beyond those available with standard SQL. They are used to develop applications and a way of accessing data. However, using the database programming languages is not just for developers. Besides doing code reviews, there are plenty of times for DBAs to use these languages to write procedures for monitoring databases, performing maintenance, and moving or loading data.
The database programming languages have some similar characteristics, but each takes advantage of some features that are platform-specific. For both, you define the variables and code ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
