Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View diiegomatias's full-sized avatar

diiegomatias

View GitHub Profile
@diiegomatias
diiegomatias / gist:4008077
Created November 3, 2012 17:38
Códigos SQL #
/*CREATE MATERIALIZED VIEW log_todos_clientes ON */
/* VIEW MATERIALIZADA PARA REPLICAR TODOS OS CLIENTES NA MATRIZ */
CREATE MATERIALIZED VIEW todos_clientes AS
BUILD IMMEDIATE
REFRESH COMPLETE
ON COMMIT AS
select * from clientes
UNION
@diiegomatias
diiegomatias / Códigos SQL
Created November 3, 2012 17:39 — forked from nersoh/Códigos SQL
BDD
/*CREATE MATERIALIZED VIEW log_todos_clientes ON */
/* VIEW MATERIALIZADA PARA REPLICAR TODOS OS CLIENTES NA MATRIZ */
CREATE MATERIALIZED VIEW todos_clientes AS
BUILD IMMEDIATE
REFRESH COMPLETE
ON COMMIT AS
select * from clientes
UNION