Skip to content

Instantly share code, notes, and snippets.

@sachin-handiekar

sachin-handiekar/aq-qtbl-xmlpayload.sql

Created November 3, 2011 21:31
Show Gist options
  • Save sachin-handiekar/1337835 to your computer and use it in GitHub Desktop.
Save sachin-handiekar/1337835 to your computer and use it in GitHub Desktop.
Download ZIP
Create a Oracle AQ Queue Table with XMLType payload
Raw
aq-qtbl-xmlpayload.sql
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE( Queue_table => 'QT_SAMPLE', Queue_payload_type => 'SYS.XMLTYPE', Sort_list => 'ENQ_TIME', COMMENT => 'A sample queue table');
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment