OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Condition In Apex (Apex4.0,Oracle 10g,Win7 32 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Condition In Apex [message #618360]

Fri, 11 July 2014 04:56

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

Report message to a moderator

Re: Condition In Apex [message #618367 is a reply to message #618360]

Fri, 11 July 2014 05:31

Littlefoot
Messages: 21761
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

Report message to a moderator

Re: Condition In Apex [message #618378 is a reply to message #618367]

Fri, 11 July 2014 07:11

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.

Report message to a moderator

Re: Condition In Apex [message #618424 is a reply to message #618378]

Fri, 11 July 2014 11:25

Littlefoot
Messages: 21761
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.

Report message to a moderator

Re: Condition In Apex [message #618562 is a reply to message #618424]

Sun, 13 July 2014 10:16

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Thanks Littlefoot for significant information.

Report message to a moderator

Previous Topic:	HTTPS Configuration for accessing APEX
Next Topic:	Region Item Button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 01:51:41 CDT 2023