1) BEST LINK: 

   Step by Step guide on creating Queue Table, En-queuing, De-queuing, Subscribing PL/SQL to Queue etc.,

    http://www.oracle-developer.net/display.php?id=411

    This is the best link for implementing AQ. This uses PL/SQL for both queuing and de-queuing. 

    Note: 
    (a) While creating the Queue table, Multi user option must be set to TRUE, for any multi-user scenarios. 

    On creating a Message Type, Queue table with the Message Type, En-queuing, Subscribe to Queue, De-queuing: 
    
    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8760267539329,

    
3) Just an additional info: 

    Demo - Advanced Queuing with Oracle Forms 11g:

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/forms/11g/formschataq/formschataq.htm#s1


4) Link to PL/SQL AQ based packages:

    http://docs.oracle.com/cd/B10500_01/appdev.920/a96587/qintro.htm
Interfaces to Advanced QueuingYou can access Advanced Queuing functionality through the following interfaces:

• PL/SQL using DBMS_AQ, DBMS_AQADM, and DBMS_AQELM. Refer to the Oracle9i Supplied PL/SQL Packages and Types Reference.
• Visual Basic using Oracle Objects for OLE. Refer to the Online Help for Oracle Objects for OLE.
• Java using the oracle.AQ Java package. Refer to the Oracle9i Supplied Java Packages Reference.
• Java Message Service (JMS) using the oracle.jms Java package. Refer to the Oracle9i Supplied Java Packages Reference.
• Internet access using HTTP, HTTPS, and SMTP