Re: Passing parameters to views...

Hi,

You can always pass parameters to a view ( using "WHERE" predicate ). So create a view and U can limit the range by specifying "WHERE" clause on that view.

Here is an example

CREATE OR REPLACE VIEW emp_view
AS
SELECT a.name,b.dept_name FROM emp a,dept b WHERE a.deptno=b.deptno;

SELECT * from emp_view
WHERE dept_name='MARKETING';

Mohamed.

maylee wrote:

> I need to create a view for a group of tables based on a range of values
> (i.e. date ranges)
> I was wondering if there is a way to pass parameters to a view, so only
> this range will be in teh view.
>
> The underlying tables grow exponentially, so a regular view would return
> too much data. I need to limit it somehow.
>
> Thanks,
> Maylee
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 12 2000 - 16:33:35 CST