PL/SQL: Materialized Views Part-1

PL/SQL (Programming Language)

type

Subroutine

SQL (Programming Language)

inout

Software

Data

System

parameters

security

tables

columns

rowid

rownum

reusable

program

performance

stored

database

user

calling program

called

anonymous

begin

declare

end

query

Query Language (Literature Subject)

null

triggers

rowlevel

statement

triggering table

event

timing

co-relation identifiers

:old

:new

Database Trigger

Materialized View

fast

refresh

complete

full

force

MV log

demand

commit