I believe Oracle AQ require license. If you have paid for it, ask them for samples and demo programs on how to interface to their AQ.
In my opinion, there are so many Open Source messaging system around that can be used instead. Of cuz it is entirely your or your company decision to use Oracle AQ instead.
Oracle is great as a relational database. For non-database stuff they are offering, there are better cheaper or even free alternatives elsewhere. E.g do you feel you need to pay monies to get a XML parser ?
Of cuz sometimes in an organization, developers have no say over those decision. So yes if your company has paid the license, I believe Oracle would have samples or demo programs on how to interface to their AQ.