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
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
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..?
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..
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
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
Previous Topic: Apex Tutorial
Next Topic: How can Pass more variable in Column Link
Goto Forum:
  


Current Time: Thu Mar 28 13:41:38 CDT 2024