>Assuming you have an access to the view, you just need
>
>select * from myView -- using the right database
>
>to get the information.
or
select * from myDatabase.mySchema.myView, so no need of using the right database :)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges