Commands for creating a materialized view

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc

Poston Wed, 09 Feb 2005 9:31 am

Could someone pass me the commands as you create a materialized view?
david ribeiro guilherme
Location: Catanduva - SP

David Ribeiro Guilherme

Poston Mon, 21 Feb 2005 2:18 pm

CREATE MATERIALIZED VIEW FAST REFRESH mv1 ON COMMIT IMMEDIATE BUILD the SELECT t. month, p. prod_name, SUM (sales) AS sum_sales FROM time t, product p, fact f WHERE f. curDate = t. curDate AND f. item = item GROUP BY p. t. month, p. prod_name;
Location: Videira - SC

  • See also
    Last Post

    Return to SQL

    Who is online

    Users browsing this forum: No registered users and 2 guests