Re: Create a view using OUT values from a procedure - how?

Serge Rielau wrote:

> In ASNI SQL it should look something like that
>
> create type x as (a int, b int);
> create function foobar...
> returns x
> .....
> return x().a(val1).a(val2);
> ...
>
> create view v(a, b)
> as select my_x.a, my_x.b
> from (select foobar(c1) as my_x from t)
>
> I'm aware the Oracle syntax is not quite the same, but it should be
> equivalent...
>
> Cheers
> Serge

There are many ways and, of course, this is one.

But they all equire someone to make some effort on their own behalf.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)