Skip to content

Instantly share code, notes, and snippets.

Avatar

Nelson Henrique nersoh

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