Re: Interesting Distributed UNION Question

Malcolm Dew-Jones wrote:

> DA Morgan (damorgan_at_x.washington.edu) wrote:
> : Malcolm Dew-Jones wrote:
>
> : > Is there not a way in oracle to use package procedures to create a "pseudo
> : > view:? The package procedure would then query just the one server you
> : > need. I forget the name, but the select would be like
> : >
> : > select whatever from fake-table-provided-by-package
> : >
> : >
> : > (Perhaps this isn't oracle, I saw it discussed some ago.)
>
> : You can not query a package though you could use piplelined table
> : functions.
>
> "pipelined table functions" - ah yes, that's the term I was looking for,
> thanks, one day I'm sure I'll to want to use them.
>
> : But still the question remains ... if you logically know
> : where to query ... why aren't you doing it and if you don't ... you
> : can't.
>
> But I thought he said. The program that makes the query _does_ know where
> to query from, but can only provide this information as part of the where
> clause.
>
> I don't know what ever program he is using, but I can imagine the program
> displays a dialog box, the user selects a choice (in this case the name of
> the server to report on), then the program inserts that choice (the server
> name) into the where clause and runs the query. (or something like that)

If the program can provide the information it can not possibly be "only in the WHERE clause."

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