Re: Interesting Distributed UNION Question

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) Received on Sat Oct 30 2004 - 18:49:54 CDT