Home » Developer & Programmer » Warehouse Builder » For loop in OWB (OWB10g R2, Win XP)
For loop in OWB [message #338498] Tue, 05 August 2008 04:27 Go to next message
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

Re: For loop in OWB [message #343840 is a reply to message #338498] Thu, 28 August 2008 05:58 Go to previous messageGo to next message
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
Re: For loop in OWB [message #344573 is a reply to message #343840] Sat, 30 August 2008 12:18 Go to previous messageGo to next message
mbhkr5
Messages: 20
Registered: October 2007
Junior Member
Hi John,

Thanks for the reply.

Can u just brief the usage of it

Thanks
Joshna
Re: For loop in OWB [message #420186 is a reply to message #338498] Thu, 27 August 2009 07:51 Go to previous message
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
Previous Topic: mapping problem
Next Topic: how to edit the source module version?
Goto Forum:
  


Current Time: Sat Dec 03 03:50:08 CST 2016

Total time taken to generate the page: 0.11036 seconds