1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| dev001> drop table testjp;
Table dropped.
dev001>
dev001> create table testjp(a int,b clob null,c char(4));
Table created.
dev001>
dev001> CREATE OR REPLACE TRIGGER TS_TESTJP
2 BEFORE INSERT
3 ON testjp
4 REFERENCING OLD AS OLD NEW AS NEW
5 FOR EACH ROW
6 DECLARE
7 LExistant NUMBER;
8 BEGIN
9 IF(dbms_lob.instr(:NEW.b,'TEST') > 0 ) THEN
10 :NEW.c := 'Asie';
11 END IF;
12 END;
13 /
Trigger created.
dev001> show errors
No errors.
dev001>
dev001>
dev001> insert into testjp values (1,'lgkjds mlkgsd¨mkl qlkngsk gzeopin,gzer TES
T pkojgsd^lpbgsdg$^gs¨md','Euro');
1 row created.
dev001>
dev001>
dev001> insert into testjp (a, b, c) values (2, null,'TTTT');
1 row created.
dev001>
dev001> insert into testjp (a, b, c) values (3, empty_clob(),'TTTT');
1 row created.
dev001>
dev001> select a from testjp;
A
----------
1
2
3 |
Partager