what do you think happens with appended spaces in sql

select len('dfdf       ')

select len('       dfdf')

in oracle too!


select * from
(

select 'sdff   ' a  from dual
)  main

where main.a ='sdff'