Skip to content

Instantly share code, notes, and snippets.

Avatar

Nelson Henrique nersoh

View GitHub Profile
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
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
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