随笔分类 -  PL/SQL

摘要：1 PL/pgSQL Under the Hood This part discusses some implementation details that are frequently important for PL/pgSQL users to know. 1.1 Variable Subst 阅读全文

摘要：Trigger Procedures PL/pgSQL can be used to define trigger procedures on data changes or database events. A trigger procedure is created with the CREAT 阅读全文

摘要：Errors and Messages 1. Reporting Errors and Messages Use the RAISE statement to report messages and raise errors. The level option specifies the error 阅读全文

摘要：Cursors Rather than executing a whole query at once, it is possible to set up a cursor that encapsulates the query, and then read the query result a f 阅读全文

摘要：Control Structures of PL/SQL Control structures are probably the most useful (and important) part of PL/pgSQL.With PL/pgSQL's control structures, you 阅读全文

摘要：1.Structure of PL/pgSQL The structure of PL/pgSQL is like below: A label is only needed if you want to identify the block for use in an EXIT statement 阅读全文