DBMS_AQADM.CREATE_QUEUE_TABLE : DBMS_AQADM « System Packages « Oracle PL / SQL






DBMS_AQADM.CREATE_QUEUE_TABLE

 
SQL>
SQL> SET ECHO ON
SQL>
SQL>
SQL> CREATE OR REPLACE TYPE emp_chg AS OBJECT (
  2      emp_id NUMBER,
  3      pay_rate NUMBER(9,2),
  4      pay_type CHAR(1),
  5      leave_dept NUMBER
  6      );
  7  /


SQL>
SQL> BEGIN
  2      DBMS_AQADM.CREATE_QUEUE_TABLE (
  3          'EMP_CHANGES',
  4          'EMP_CHG',
  5          NULL,
  6          'priority,enq_time',
  7          TRUE,
  8          DBMS_AQADM.NONE,
  9          'For pay rate and department changes.',
 10          TRUE,0,0,
 11          '8.1'
 12          );
 13  END;
 14  /



SQL>
SQL> --

 








Related examples in the same category

1.DBMS_AQADM.CREATE_QUEUE
2.DBMS_AQADM.START_QUEUE