Hi,
I have a question regarding writing an oracle view.
I have a requirement in which, I have refer a table1 and if i find information from that, I have return as part of view1.
And if table1 does not return a value, I have to query table2 and provide the result set.
I wanted to write 2 select statements like a plsql block, but as a create view has only one select statement, I'm little confused.
Any suggestion is appreciated.
Thank you.
Jay