Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

filling the gaps

770280Jul 16 2010 — edited Jul 16 2010
Hi Gurus!

I have a table ff, that has 2 columns id_1 and id_2.
with ff as
(
select 1 id_1, 1    id_2 from dual union all
select 2 id_1, null id_2 from dual union all
select 3 id_1, null id_2 from dual union all
select 4 id_1, 2    id_2 from dual union all
select 5 id_1, 3    id_2 from dual union all
select 6 id_1, null id_2 from dual union all
select 7 id_1, 4    id_2 from dual 

)select * from ff

ID_1	ID_2
------------
1	1
2	
3	
4	2
5	3
6	
7	4
Desired output:
ID_1	ID_2
------------
1	1
2	1
3	1
4	2
5	3
6	3
7	4
Hope this makes sense

Thanks
This post has been answered by Aketi Jyuuzou on Jul 16 2010
Jump to Answer

Comments

Timo Hahn
Mohamed,
as you are using 11.1.1.3.0 and not 10g (10.3.1?) this tutorial is not meant for your version.
You should use a bounded task flow with a start activity which resets the form. Depending on the use case this can be done by calling createInsert on the vo you want to enter data into, or by clearing the inputFiled which are bound to a bean or something else.
For a sample of the first check http://tompeez.wordpress.com/2012/12/01/jdeveloper-11-1-1-5-0-use-router-to-create-new-row-or-edit-existing/


Timo
MFadel
Thanks for your reply Timo,

That's the first time i've heard of the router! In your sample application, you set the default outcome to "edit". So this means there's only 2 outcomes : insert and edit in the router's functionality?
And that you set the default to be edit?

By the way, this is just a general question, I'm not trying to do anything for now.

Regards,
Mohamed.
Timo Hahn
Mohamed,
routers are not only for create/edit but can have multiple outcomes. Check the doc http://docs.oracle.com/cd/E35521_01/web.111230/e16182/taskflows_activities.htm#ADFFD1673 to find out more about how to use them.

Timo
MFadel
I'll check them out now!

Thanks Timo:)
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 13 2010
Added on Jul 16 2010
5 comments
949 views