Skip to Main Content

Oracle Database Discussions

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!

analytical function help

OU_230Sep 18 2017 — edited Sep 19 2017

I have following table:

with  tbl as (select 1 col1, 'a'  col2 from dual

            union select 2 , 'a' from dual

            union  select 3 , 'b' from dual

            union  select 4 , 'a' from dual

            union  select 5 , 'a' from dual

            union  select 6 , 'b' from dual

            union  select 7 , 'b' from dual

) select   * from tbl order by col1;

I want following result  i.e first value from  col2   whenever col2 value changes.

1 ,a

3 ,b

4 ,a

6 ,b

How can I do this in SQL  using analytical function

This post has been answered by ddf_dba on Sep 18 2017
Jump to Answer

Comments

2954860

Also, completeBulk has run successfully for the same model with several other, smaller datasets.

Sdas-Oracle

A SQL insert/append command seems to have failed. Please check if there is enough space on the tablespaces.

Also, feel free to contact me directly at souripriya dot das at oracle dot com.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 17 2017
Added on Sep 18 2017
5 comments
580 views