Re: materialized view. help...

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 25 Aug 2003 12:38:32 -0700
Message-ID: <3722db.0308251138.576116f3_at_posting.google.com>

According to what I see in the Data Warehouse manual (http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/mv.htm#721), inline views (i.e. what you try) is only possible in the FROM clause of the MV definition, and not in the SELECT clause, as you are trying.

Daniel Received on Mon Aug 25 2003 - 21:38:32 CEST

This message: [ Message body ]
Next message: jt: "How do I rename null values found in GROUP BY column?"
Previous message: rp_3: "Re: Difficulty inserting due to &"
Maybe in reply to: anna: "materialized view. help..."
Next in thread: jt: "Re: How do I rename null values found in GROUP BY column?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message