-
Creating Oracle Views on the fly
-
Re: Creating Oracle Views on the fly
"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.
-
Re: Creating Oracle Views on the fly
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|