Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006

    Unanswered: creating materialized views with cursors

    Can someone give me the correct syntax for creating a materialized view with a cursor in Oracle?


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    What would that exactly be? As far as I know, cursors have nothing to do with materialized views. Did you perhaps mix terms? What are you trying to do?

    Materialized views (formerly known as snapshots are database objects that store result of a query. Usually they are used to locally store data that, actually, exists in a remote database, for warehousing purposes etc.

    Read more about the concept and the way materialized views are created.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts