how to select command more than one databese values in a single query.
pls send me with examples
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Anuja PawarPosted Jan 24, 2012, 4:29 AM
SELECT *FROM pubs.dbo.authors
Table names (and all database objects) can be qualified with the database name and owner name of the object with the syntax:
. . . FROM DatabaseName.OwnerName.ObjectName . . .You could also use something like this:
SELECT *
FROM pubs..authors
For more refer this link
http://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_distdbs.htm#BABIFEFB