Simple example - View-VENCODING

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips

Description Columns Query Constraints Triggers

VENCODING

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable	Comment
COL	VARCHAR2(30)	Y	YES	YES	YES

Query:

Legend: comment string keyword reserved word operator

select COL from encoding

Triggers

IOFT_VENCODING

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
ioft_vencoding
 INSTEAD OF INSERT
 ON vencoding
 FOR EACH ROW
 
REFERENCING NEW AS NEW OLD AS OLD
BEGIN
   INSERT INTO encoding values('IOFT demo: foo')
 END;