| Message Queues [message #110230] |
Fri, 04 March 2005 07:20  |
mbhavna
Messages: 3
Registered: March 2005
Location: Mumbai
|
Junior Member |
|
|
Hi,
Can anybody tell me...
What is the difference between message queues and dblinks?
Thanks and Regards,
|
|
|
|
| Re: Message Queues [message #110234 is a reply to message #110230] |
Fri, 04 March 2005 08:37  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
I may not be exactly right in this definition on queuing.
In simple words,
It is an oracle functionality that helps for interprocess communication between different modules/applications/webinterfaces/databases etc ( like publish and subscribe). A google search or browse through documentation should help more precisely.
A dblink is just a link to another oracle database.
-- this will query the database connected to CURRENTLY.
sql> select * from emp;
-- this will query the table emp residing in a remote database
-- or other database.
-- myremotedb is the name of databaselink ( which precrated to connect to a particular user in remotedb and is hardcoded with the password)
-- Search in this forum/google/docs for more examples.
sql> select * from emp@myremotedb;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
