hi,
I've these tables:
CREATE TABLE TAB1
(
ID VARCHAR2(64),
NAME VARCHAR2(64)
)
ID...............NAME
1................AAA;2;BBB
B;4;FFFFF;
3;RRRRR;2;
3................AAA;2;CCC
;2;DDD;3;
6...............TTTT;3;NNN
N;5;
..........................
.....
..........................
.... more 100 rows
CREATE TABLE TAB2
(
COD_ID VARCHAR2(64),
NAME_TYPE VARCHAR2(64)
)
I'd like to create a trigger on TAB1 that when I insert a new record into TAB1 I get these records into TAB2:
COD_ID................NAME
1....................AAA
1....................AAA -- 2 records with AAA (AAA;2)
1....................BBBB
1....................BBBB
1....................BBBB
1....................BBBB -- 4 records with BBBB (BBBB;4)
1....................FFFFF
1....................FFFFF
1....................FFFFF
-- 3 records with FFFFF (FFFFF;3)
1....................RRRRR
1....................RRRRR
-- 2 records with RRRRR (RRRRR;2)
3....................AAA
3....................AAA
3....................CCC
3....................CCC
3....................DDD
3....................DDD
3....................DDD
6....................TTTT
6....................TTTT
6....................TTTT
6....................NNNN
6....................NNNN
6....................NNNN
6....................NNNN
6....................NNNN
..........................
...
..........................
.....
How can I create this trigger to get my output?
Thanks in advance!
Start Free Trial
