Home » SQL & PL/SQL » SQL & PL/SQL » Creating Views with parameters..
Creating Views with parameters.. [message #37375] Sun, 03 February 2002 23:18 Go to next message
diaz
Messages: 58
Registered: October 2001
Member
hello..

usually if i want to build view..
is just doing like this:

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

now.. i wanted to make the view is filtered..
like having this clause : where a is greater than b

can you tell me how to make it ?
thanks
Re: Creating Views with parameters..(revised question) [message #37376 is a reply to message #37375] Sun, 03 February 2002 23:54 Go to previous message
diaz
Messages: 58
Registered: October 2001
Member
what i mean is not something fixed like this

CREATE VIEW student_v of student_t UNDER person_v AS
SELECT ssn, name, address, deptid, major FROM allpersons
WHERE typeid = 2;
^^^^^^^^^^
the typeid can be input from the outside of the code ..
Previous Topic: Alias cannot be used in function? Thank you in advance.
Next Topic: Is it possible to.....
Goto Forum:
  


Current Time: Fri Mar 29 07:15:01 CDT 2024