User Profile

Collapse

Profile Sidebar

Collapse
altafasa2
altafasa2
Last Activity: Mar 12 '08, 04:09 PM
Joined: Dec 4 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • altafasa2
    started a topic Materialize View
    in Oracle

    Materialize View

    ORIGINAL MATERIALIZE VIEW QUERY:-

    [code=oracle]

    select gb.SET_OF_BOOKS _ID "SOB_ID"
    , gcc.CODE_COMBIN ATION_ID "CCID"
    , gp.period_name
    , gb.ACTUAL_FLAG
    , gcc.segment1
    , gcc.segment2
    , gcc.segment3
    , gcc.segment4
    , gcc.segment5
    , gcc.segment6
    ...
    See more | Go to post
    Last edited by amitpatel66; Dec 6 '07, 06:32 AM. Reason: code tags
    • altafasa2
      replied to Materialized Views in Oracle
      in Oracle
      Materialize view is actual object created in the Database based on the undelying select statement. Also it can be configured to referesh automatically based on specified time schedule.
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...