How to select command more than one databese values in a single query

Question

how to select command more than one databese values in a single query. pls send me with examples

Anuja Pawar · Answer

Hi Magesh 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