Home » SQL & PL/SQL » SQL & PL/SQL » Re: Creating Schema Objects Through Procedures
Re: Creating Schema Objects Through Procedures [message #37374] Sun, 03 February 2002 21:40
diaz
Messages: 58
Registered: October 2001
Member
hello..
what if i want to build view that contain records from some query like this :

select a, b, c from mytable where paydate is null

so.. it has other parameters to build the view that is the paydate..
while usually.. we can build view just by doing this

select a,b from mytable
union all
select a,b from yourtable

can somebody help me here ?
thanks

Report message to a moderator

Previous Topic: Query for table spaces
Next Topic: Alias cannot be used in function? Thank you in advance.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 13:19:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.