Re: how do i create a view within a procedure that uses a variable defined in the procedure

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 12:13:44 -0500

Linda,

>> You need to get out more. :) <<

Well, apparently I have gotten out well enough not to confuse data
management with scheduled creation of tables and/or views :-)

>> Of course there is a real need in the real world. Partitioned views come
to mind immediately. <<

Dealing with data sources external to the DBMS or certain specialized data
processing schemes may require some amount of automation and organizations
use various ways to accomodate these processes with procedures creating &
destroying ad hoc tables, view etc. Even a simple DTS process that creates a
table or meta-data related procedures for that matter would be such an
instance.

Categorizing all such processes and workarounds as relational data
management is like labeling all that glitters as gold. Data management in
relational databases involves imposing structural, manipulative and
integrity dictums for logical data representation.

And that is exactly why I asked the OP to post his overall requirements
rather than what he perceived as an immediate need. 

-- 
Anith