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

    Unanswered: creating materialized views with cursors

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

    Thanks,
    neto

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    There isn't any - your question makes no sense! A materialized view is a table whose contents are maintained automatically, based on a SELECT statement. There is no cursor involved.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by neto
    Can someone give me the correct syntax for creating a materialized view with a cursor?
    Why do you ask the same question twice?

    Littlefoot has already answered your question the first time:
    http://www.dbforums.com/showthread.php?t=1218715
    Which is essentially the same answer you got this time from andrewst.

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Yes, I hadn't noticed the other post when I replied. But it looks like this is accidental - e.g. press submit, nothing seems to happen, press again... Easily done!

Posting Permissions

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