SQL Language (MOSC)

MOSC Banner

update with row_number() giving unexpected results

edited Jun 20, 2012 4:29PM in SQL Language (MOSC) 13 commentsAnswered ✓
Hello,

I'm getting unexpected results doing the following update statement :

create table test(a varchar2(10));
insert into test values('ab');
insert into test values('a_b');
insert into test values('_ab');
insert into test values('!!ab');
insert into test values('!!abc');
insert into test values('bc');
insert into test values('abc');

create table results (a varchar2(10), rn int);
insert into results(rn) values(1);
insert into results(rn) values(2);
insert into results(rn) values(3);
insert into results(rn) values(4);
insert into results(rn) values(5);
insert into results(rn) values(6);
insert into results(rn) values(7);
commit;

update results set a = (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center