Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Saving to two different tables
icon9.gif  Saving to two different tables [message #328889] Mon, 23 June 2008 04:32 Go to next message
gloveracle
Messages: 4
Registered: May 2008
Location: Makati City
Junior Member
Guys, please help me on, how to add data in two different table on Oracle Application express.. Im just new to this, that's why im asking.. please cite me an example.. thankz

Report message to a moderator

Re: Saving to two different tables [message #328909 is a reply to message #328889] Mon, 23 June 2008 05:22 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
create view / materialised view on two different tables and use the view... rest of things in apex as usual done for single table

yours
dr.s.raghunathan

Report message to a moderator

Re: Saving to two different tables [message #329036 is a reply to message #328909] Mon, 23 June 2008 19:23 Go to previous messageGo to next message
gloveracle
Messages: 4
Registered: May 2008
Location: Makati City
Junior Member
how would i be able to put that view on apex..?

Report message to a moderator

Re: Saving to two different tables [message #329038 is a reply to message #328909] Mon, 23 June 2008 19:41 Go to previous messageGo to next message
gloveracle
Messages: 4
Registered: May 2008
Location: Makati City
Junior Member
dr.s.raghunathan wrote on Mon, 23 June 2008 05:22
create view / materialised view on two different tables and use the view... rest of things in apex as usual done for single table

yours
dr.s.raghunathan


Is it applicable to save on view? my problem is how to save data from same field in two different table.. thankx.. i hope you could help me..

Report message to a moderator

Re: Saving to two different tables [message #329109 is a reply to message #329038] Tue, 24 June 2008 02:59 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
if not voluminours why don't you try to create trigger on one table to update parallaly in another table

yours
dr.s.raghunathan

Report message to a moderator

Re: Saving to two different tables [message #389348 is a reply to message #328889] Sun, 01 March 2009 01:58 Go to previous message
craig67
Messages: 8
Registered: February 2009
Junior Member
create a page process and then you can use PLSQL to update as many tables as you want.


Craig
www.oracleapplicationexpress.com

Report message to a moderator

Previous Topic: Apex Tutorial
Next Topic: How can Pass more variable in Column Link
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Oct 02 22:47:02 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.