call view from view
986173Jan 21 2013 — edited Jan 28 2013I want to create a view that can reference to several other views which extract data from other views. All the views involved are created by me. It seems working fine if I use a third party software (Navicat), but if I use Microsoft Excel or from Web, I am given an error saying the view does not exist. I suspect if Oracle does not allow cross references of user views. Is that true?