Creating Oracle Views on the fly


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Creating Oracle Views on the fly

  1. #1
    Neil Donald Guest

    Creating Oracle Views on the fly




  2. #2
    Neil Guest

    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.

  3. #3
    dnagel Guest

    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center