| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Parameterized Views
CEATE VIEW v_view AS
select delegate_userid, orgid, login
from table1
union
select delegate_userid, orgid, login
from table2
union
select delegate_userid, orgid, login
from table3
then do
select * from v_view
where login = 'SOME_USER'
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 19 2007 - 13:21:44 CDT
 |
 |