Discussion on: SQL: Where spaces may not matter

[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

[Ross Henderson]

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