DEV Community


Discussion on: SQL: Where spaces may not matter

antogarand profile image
Antony Garand Author

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

Thread Thread
scottishross profile image
Ross Henderson

Ran in Oracle SQLDev:

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

Result: 1

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

Edit: I should mention that this is on 18.2