Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Condition In Apex (Apex4.0,Oracle 10g,Win7 32 bit)
Condition In Apex [message #618360] Fri, 11 July 2014 04:56 Go to next message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
Hello,
I have two different condition in one page like if 1st condition is true than update the table1 and if 2nd condition is true then update table2,
So how can i maintain 2 update statement in one page .
what is the appropriate via to do this .Please help me out .

Thanks,
Xandot
Re: Condition In Apex [message #618367 is a reply to message #618360] Fri, 11 July 2014 05:31 Go to previous messageGo to next message
Littlefoot
Messages: 21562
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
To me, it looks like one process with an IF:
if condition_1 then
   update table_1
elsif condition_2 then
   update table_2
end if
Re: Condition In Apex [message #618378 is a reply to message #618367] Fri, 11 July 2014 07:11 Go to previous messageGo to next message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
okay got it.
can i put multiple update statements in one process or create a different process for each statement.
Re: Condition In Apex [message #618424 is a reply to message #618378] Fri, 11 July 2014 11:25 Go to previous messageGo to next message
Littlefoot
Messages: 21562
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Theoretically speaking, you can use as many UPDATE statements as you wish. However, you might be restricted by number of characters you are allowed to put into a process code field. If it ever happens - actually, that's what I do all the time - create a stored procedure which contains all the logic, and then call that procedure from an Apex process.
Re: Condition In Apex [message #618562 is a reply to message #618424] Sun, 13 July 2014 10:16 Go to previous message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
Thanks Littlefoot for significant information.
Previous Topic: HTTPS Configuration for accessing APEX
Next Topic: Region Item Button
Goto Forum:
  


Current Time: Tue Jun 02 20:18:12 CDT 2020