Re: Parameterized Views

  • From: "Neil Overend" <neiloverend@xxxxxxxxx>
  • To: mhyder@xxxxxxxx
  • Date: Wed, 19 Sep 2007 19:21:44 +0100

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'
--
//www.freelists.org/webpage/oracle-l


Other related posts: