You will have to be a little more specific in your request. Union all is
really not related to a view, but to a sql query. For the most part, any
SQL Query can be used to create a view. There are restrictions, but for the
most part, think of views as pre-compiled sql.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Deborah Carter" <dcarter_at_cnfei.com> wrote in message
news:WlJ45.5$BY1.446012_at_firenze.visi.net...
> Does anyone know an alternative to using the keywords 'UNION ALL' in a
join
> to create a view? I haven't found much on this and am looking for more
> information. All help is appreciated. Thanks.
>
> Deborah Carter
> Developer
>
>
Received on Fri Jun 23 2000 - 00:00:00 CDT
