Database Coding Practices
PL/SQL is a programming language with close integration to the Oracle database. Some of the standard coding practices used with T-SQL don’t translate to PL/SQL, and might even seem backward. However, some of the concepts correspond, although the coding will not be exactly the same. For example, the concept of SQL Server INSTEAD OF triggers are found in Oracle’s BEFORE triggers. Table 9-1 shows some examples of commonly used programming tools in SQL Server and Oracle. As we look at PL/SQL examples throughout this chapter, you will see how these are used in blocks of code.
TABLE 9-1. Common Code Usage in SQL Server and ...
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.
