Skip to content

Instantly share code, notes, and snippets.

View nersoh's full-sized avatar

Nelson Henrique nersoh

14 followers · 16 following
View GitHub Profile
@nersoh
nersoh / Códigos SQL
Created November 3, 2012 17:26
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
@nersoh
nersoh / gist:4008072
Created November 3, 2012 17:36
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
@nersoh
nersoh / gist:4008081
Created November 3, 2012 17:39 — forked from diiegomatias/gist:4008077
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