Creating Oracle Views on the fly

[Neil Donald]

[Neil]

"Neil Donald" <neil.donald@calanais.com> wrote:

Sorry but I accidentaly posted this without any message.

I am wanting to create Views in Oracle on the fly using ADO from Access\VB.
Has anyone tried to do this with any level of success? Any hints or tips
would be much appreciated.

Thanks in advance.

[dnagel]

Having two tables, one named Orders, the other named Customer
I will create a view 'on the fly' in the example below.

Select
MyView.CustomerID,
MyView.OrderID,
Customer.ZipCode
from
Customer,
(Select CustomerID, OrderID, SKU from Orders) MyView
where
Customer.CustomerID = MyView.CustomerID
and MyView.SKU = 123

If you're asking how to create a view that can be used outside
of a single select, I can't help. I've only ever found this
method to be useful, because as a SW developer I am usually locked
out (no privs) from creating (semi)permanent views.

hth,

D.




in "Neil" <neil.donald@calanais> wrote in message news:3cfb54d5$1@10.1.10.29...
|
| "Neil Donald" <neil.donald@calanais.com> wrote:
|
| Sorry but I accidentaly posted this without any message.
|
| I am wanting to create Views in Oracle on the fly using ADO from Access\VB.
| Has anyone tried to do this with any level of success? Any hints or tips
| would be much appreciated.
|
| Thanks in advance.