DEV Community

Discussion on: SQL: Where spaces may not matter

View post

Replies for: I'd be more than surprised if Oracle would not distinguish 'admin' from 'admin ' on insert, but I don't have an Oracle server handy to test. I c...

 
antogarand profile image
Antony Garand •

I'm not that familiar with Oracle but based on this sqlFiddle, I can confirm to you that this does work:

sqlfiddle.com/#!4/c0be1c/19813

Thread Thread
 
scottishross profile image
Ross Henderson • • Edited

Ran in Oracle SQLDev:

begin
    if 'admin' = 'admin ' then dbms_output.put_line(1);
    else dbms_output.put_line(0);
    end if;
end;

Result: 1

It is correct that Oracle automatically trims leading and trailing spaces.

Edit: I should mention that this is on 18.2