Home » SQL & PL/SQL » SQL & PL/SQL » Trigger associated with two Database
Trigger associated with two Database [message #637155] Mon, 11 May 2015 21:39 Go to next message
jknath
Messages: 1
Registered: May 2015
Location: Chennai
Junior Member
Team,

A novice question to u all as I am a fresher to Oracle.

I have written trigger and I am aware of that.

I want to write a trigger and the action is to update a record in a table which is in database1 when a record is inserted in a table which is in database2.

please guide me how to achieve this......

t1 table in database1
t2 table in database2

When a record is inserted in t1(database1), a record has to be inserted in t2(database1)...

Thanks in advance....

Report message to a moderator

Re: Trigger associated with two Database [message #637156 is a reply to message #637155] Mon, 11 May 2015 21:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

http://www.lmgtfy.com/?q=oracle+insert+trigger+example

Report message to a moderator

Re: Trigger associated with two Database [message #637161 is a reply to message #637155] Tue, 12 May 2015 00:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ Database or schema?
2/ We don't do homework so please show us what you have already tried and explain where you are stuck

Please do it in the way described in the links BlackSwan provided.

Report message to a moderator

Re: Trigger associated with two Database [message #637185 is a reply to message #637161] Tue, 12 May 2015 08:10 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Is it the same record, meaning is T2 the same as T1 or is it a different record

Report message to a moderator

Previous Topic: Oracle case statment solution
Next Topic: Temporary table space error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 05:01:42 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.