Re: Passing parameters to views...

Actually, the kind of parameter I need to pass is at runtime. The date range can change at any point, it's not a fixed value.

In article <387D00D4.62151E67_at_assigncorp.com>,   mbuhari_at_assigncorp.com wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 13 2000 - 08:37:32 CST