📄 bz_prp_cr_q.sql
字号:
REM script name: bz_pr_cr_q.sqlREM Creates queues - bzcardorders_prpqREM Starts the queueREMREM version: 9iREMREM =======================================================REM cleanup sectionREM =======================================================BEGIN dbms_aqadm.stop_queue(queue_name => 'bzcardorders_prpq'); dbms_aqadm.drop_queue ( queue_name => 'bzcardorders_prpq');END;/REM =======================================================REM Create a queue to show propagationREM =======================================================BEGINdbms_aqadm.create_queue ( queue_name => 'bzcardorders_prpq', queue_table => 'bzcardorders_qt');END;/REM =======================================================REM start queueREM =======================================================BEGIN dbms_aqadm.start_queue ( queue_name => 'bzcardorders_prpq');END;/begindbms_aqadm.grant_queue_privilege(privilege => 'ALL', queue_name => 'bzcardorders_prpq', grantee => 'bz', grant_option => TRUE);end;/begindbms_aqadm.add_subscriber(queue_name => 'bzcardorders_prpq', subscriber => sys.aq$_agent('sub1', null, null));end;/
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -