As far as I can tell this is an example of a queue where both publisher and subscriber are on the same system. How does it work when they are on separate systems? I am trying to figure out how to test an AQ which works on production, but as far as I can tell it has not been tested on a clone of our production system since it was first developed and the original development team have all left. I was expecting to be able to find the translation between the internal Oracle Queue name and the external message bus in ALL_QUEUES (the same way you can find the translation between the internal Oracle Directory name and the file system directory in ALL_DIRECTORIES) but it is not there. Nothing that I have read seems to help. The articles on AQ all show queues being created without any reference to the world outside the Oracle instance they are created on! How does that work? There must be a link somewhere surely?
Search for Oracle advance queue in the Oracle documentation. I don't know of any written book outside of the Oracle documentation that has this topic. I'll post the code on my github for you all