I am using Oracle SQL Developer client 10g. I want to know how do I create a view across Schema. I have a Schema that has all my table and views. I want to create a view in a schema that does not have any data. This is only for viewing purpose only of the view that i want to create.
Thank you,
Kevin