text in all_source ends with chr(10)

Did you know that all_source.text ends with chr(10) ?

if you want to search for /*single line comment*/ in all_source,
this will not work:

select *
from all_source
where ltrim(text) like '/*%*/'

this will work

select *
from all_source
where ltrim(text) like '/*%*/' || chr(10)

Links

• Subscribe to this feed