OraFAQ Forum: Data Integration

Home » Developer & Programmer » Data Integration » For loop in OWB (OWB10g R2, Win XP)

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

For loop in OWB [message #338498]

Tue, 05 August 2008 04:27

mbhkr5
Messages: 20
Registered: October 2007

Junior Member

Hi all,

I need to implement simple logic using OWB, which can be done easily using a procedure with for loop.

How can I implement 'for' loop in owb. 'If' can be implemented using case statement of expression.

Regards,
Joshna

Report message to a moderator

Re: For loop in OWB [message #343840 is a reply to message #338498]

Thu, 28 August 2008 05:58

aajk
Messages: 7
Registered: July 2007
Location: India

Junior Member

Hi

For implementing for loop you need to write a table function in OWb

Regards
John

Report message to a moderator

Re: For loop in OWB [message #344573 is a reply to message #343840]

Sat, 30 August 2008 12:18

mbhkr5
Messages: 20
Registered: October 2007

Junior Member

Hi John,

Thanks for the reply.

Can u just brief the usage of it

Thanks
Joshna

Report message to a moderator

Re: For loop in OWB [message #420186 is a reply to message #338498]

Thu, 27 August 2009 07:51

Omniman
Messages: 1
Registered: August 2009

Junior Member

Could you describe this a little bit more in detail, please?

I want to insert a result set into a table for a differing number of months.

In PL/SQL it would be like this:

for i in start_month .. 12 loop
insert into target_table
select
year,
i, -- >> this is my month
other_column,
value
from source_table;
commit;
end loop;

Thanx in advance for any suggestions!

Best regards,
Steffen

Report message to a moderator

Previous Topic:	mapping problem
Next Topic:	how to edit the source module version?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 18:11:29 CST 2025