| Doubts in trigger (merged by LF and MC) [message #266255] |
Mon, 10 September 2007 05:37  |
oracleram
Messages: 23
Registered: November 2006
|
Junior Member |
|
|
hi every1,
i have 2 tables say A and B
A table contains
id amt
1 1000
2 2000
3 3000
32 5000
there is a need to write a trigger to update the values of B tables While inserting values in B table
the output will be B table contains
name id1 amount1 id2 amount2 id3 amount3 id4 amount4
x 1 1000 2 2000 3 3000 32 5000
thanx in advance
[Updated on: Mon, 10 September 2007 06:33] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
| doubts in trigger [message #266266 is a reply to message #266255] |
Mon, 10 September 2007 06:07  |
oracleram
Messages: 23
Registered: November 2006
|
Junior Member |
|
|
i have 2 tables say A and B
A table contains
name id amt
x 1 1000
x 2 2000
x 3 3000
y 32 5000
x 10 600
there is a need to write a trigger to update the values of B tables While inserting values in A table
the output will be B table contains
name id1 amount1 id2 amount2 id3 amount3 id4 amount4
x 1 1000 2 2000 3 3000 10 600
y 32 5000
thanx in advance
|
|
|
|
|
|
|
|
| Re: doubts in trigger [message #266284 is a reply to message #266267] |
Mon, 10 September 2007 06:31 |
oracleram
Messages: 23
Registered: November 2006
|
Junior Member |
|
|
A table description
name varchar2(10);
id number;
amount number;
month number;
year number;
B table description
name varchar2(10);
id number;
amount number;
our objective is to insert the values of table A into table B
i have 2 tables say A and B
A table contains
name id amt month year
x 1 1000
x 2 2000
x 3 3000
y 32 5000
x 10 600
there is a need to write a trigger to update the values of B tables While inserting values in A table
the output will be B table contains
name id1 amount1 id2 amount2 id3 amount3 id4 amount4
x 1 1000 2 2000 3 3000 10 600
y 32 5000
thanx in advance
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
