How to select command more than one databese values in a single queryMMmagesh manavalan14yAsked Jan 24, 2012, 1:29 AM2.7khow to select command more than one databese values in a single query.pls send me with examples
Anuja Pawar14y agoPosted Jan 24, 2012, 4:29 AMHi Magesh,SELECT *FROM pubs.dbo.authorsTable 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..authorsFor more refer this linkhttp://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_distdbs.htm#BABIFEFB
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