Skip to Main Content

Portuguese

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Duke's Choice Award Latin America

Pabloc-OracleApr 18 2016 — edited Apr 19 2016


The Duke's Choice Award is dedicated to all members of the Java Community!

For the past 13 years, Duke's Choice Award winners have been announced at JavaOne, the world's biggest Java technology conference and gathering of Java community members.
The DCA celebrates extreme innovation using Java technology. The primary judging criteria for this prestigious award is innovation, putting small developer shops and individual developers on equal footing with global giants.

This program is open to all members of the Java Community and nominations can be submitted by anyone (including Oracle employees).
Deadline for submission is May 16th, 2016.
Nominate today!

All 3 Duke's Choice Award winners will receive a free JavaOne Latin America full conference pass, a Duke statue, 2016 winner badge, inclusion in corporate social media programs, and most rewarding of all, community recognition as an elite member of the Java ecosystem.

https://community.oracle.com/servlet/JiveServlet/showImage/73-11226-144663/140928_OpenWorld_JavaOne_DukesChoiceAwards_2172.jpg

Comments

450441
Isn't DENSE_RANK() OVER (partition by c_id, name ... ) what you want?
Aketi Jyuuzou
with WorkView as (
SELECT 'GULSU1' NAME, 111 C_ID,10 as SortKey FROM DUAL UNION
SELECT 'GULSU1', 111,20 FROM DUAL UNION
SELECT 'GULSU1', 111,30 FROM DUAL UNION
SELECT 'GULSU1', 111,40 FROM DUAL UNION
SELECT 'GULSU1', 111,50 FROM DUAL UNION
SELECT 'GULSU1', 111,60 FROM DUAL UNION
SELECT 'GULSU1', 111,70 FROM DUAL UNION
SELECT 'GULSU1', 111,80 FROM DUAL UNION
SELECT 'GULSU1', 111,90 FROM DUAL UNION
SELECT 'GULSU2', 112,100 FROM DUAL UNION
SELECT 'GULSU2', 112,110 FROM DUAL UNION
SELECT 'GULSU2', 112,120 FROM DUAL UNION
SELECT 'GULSU2', 112,130 FROM DUAL UNION
SELECT 'GULSU2', 112,140 FROM DUAL UNION
SELECT 'GULSU2', 112,150 FROM DUAL UNION
SELECT 'GULSU2', 112,160 FROM DUAL UNION
SELECT 'GULSU1', 112,170 FROM DUAL UNION
SELECT 'GULSU1', 112,180 FROM DUAL)
select NAME,C_ID,SortKey,
sum(willSum) over(partition by NAME order by SortKey) as version
from (select NAME,C_ID,SortKey,
       case when lnnvl(NAME = Lag(NAME) over(order by SortKey))
            then 1 else 0 end as willSum
       from WorkView)
order by SortKey;

NAME    C_ID  SortKey  version
------  ----  -------  -------
GULSU1   111       10        1
GULSU1   111       20        1
GULSU1   111       30        1
GULSU1   111       40        1
GULSU1   111       50        1
GULSU1   111       60        1
GULSU1   111       70        1
GULSU1   111       80        1
GULSU1   111       90        1
GULSU2   112      100        1
GULSU2   112      110        1
GULSU2   112      120        1
GULSU2   112      130        1
GULSU2   112      140        1
GULSU2   112      150        1
GULSU2   112      160        1
GULSU1   112      170        2
GULSU1   112      180        2
On Oracke9i,
we must emulate lnnvl.

similar thread
450745

and my site :-)
http://www.geocities.jp/oraclesqlpuzzle/10-130.html
1 - 2

Post Details

Added on Apr 18 2016
0 comments
595 views