Пример 6.1. Задание альтернативного терминатора SET TERM ^; CREATE OR ALTER PROCEDURE SHIP_ORDER ( PO_NUM CHAR(8)) AS BEGIN /* Тело хранимой процедуры */ END^ /* Другие хранимые процедуры и триггеры Процедурный язык PSQL 384 PO_NUM CHAR(8)) AS DECLARE VARIABLE ord_stat CHAR(7); DECLARE VARIABLE hold_stat CHAR(1); DECLARE VARIABLE cust_no INTEGER; DECLARE VARIABLE any_po CHAR(8); BEGIN SELECT order_status, c.on_hold, c.cust_no FROM sales s, customer c WHERE po_number = :po_num AND s.cust_no = c.cust_no INTO :ord_stat, :hold_stat, :cust_no;

character as an alternative terminator character: SET TERM ^; CREATE OR ALTER PROCEDURE SHIP_ORDER ( PO_NUM CHAR(8)) AS BEGIN /* Stored procedure body */ END^ /* Other stored procedures and triggers */ PROCEDURE SHIP_ORDER ( PO_NUM CHAR(8)) AS DECLARE VARIABLE ord_stat CHAR(7); DECLARE VARIABLE hold_stat CHAR(1); DECLARE VARIABLE cust_no INTEGER; DECLARE VARIABLE any_po CHAR(8); BEGIN SELECT s.order_status, c.on_hold, c.cust_no FROM sales s, customer c WHERE po_number = :po_num AND s.cust_no = c.cust_no INTO :ord_stat, :hold_stat, :cust_no; IF

character as an alternative terminator character: SET TERM ^; CREATE OR ALTER PROCEDURE SHIP_ORDER ( PO_NUM CHAR(8)) AS BEGIN /* Stored procedure body */ END^ /* Other stored procedures and triggers */ PROCEDURE SHIP_ORDER ( PO_NUM CHAR(8)) AS DECLARE VARIABLE ord_stat CHAR(7); DECLARE VARIABLE hold_stat CHAR(1); DECLARE VARIABLE cust_no INTEGER; DECLARE VARIABLE any_po CHAR(8); BEGIN SELECT s.order_status, c.on_hold, c.cust_no FROM sales s, customer c WHERE po_number = :po_num AND s.cust_no = c.cust_no INTO :ord_stat, :hold_stat, :cust_no; IF

übergeben: Zeichen als alternatives Abschlusszeichen: SET TERM ^; CREATE OR ALTER PROCEDURE SHIP_ORDER ( PO_NUM CHAR(8)) AS BEGIN /* Stored procedure body */ END^ /* Other stored procedures and triggers */ PROCEDURE SHIP_ORDER ( PO_NUM CHAR(8)) AS DECLARE VARIABLE ord_stat CHAR(7); DECLARE VARIABLE hold_stat CHAR(1); DECLARE VARIABLE cust_no INTEGER; DECLARE VARIABLE any_po CHAR(8); BEGIN SELECT s.order_status, c.on_hold, c.cust_no FROM sales s, customer c WHERE po_number = :po_num AND s.cust_no = c.cust_no INTO :ord_stat, :hold_stat, :cust_no; IF