To check space in varchar2 column

[bsathishmca]

Hi Guiders,

I need to check the whether space is there in verchar column or not.


select a.mycol1,a.myco l2 from mytable a where (decode(length( a.mycol1),lengt h(rtrim(a.mycol 1)),'No') is NULL and a.prcs_dte='11-Aug-2008';

The above query only i have used.But i need to check for n number of varchar columns in same table.Can any one suggest me.

Note : I have only select permission on the tables.So i could not able to use user_tab_col.

[r035198x]

Why not just use INSTR ?

[debasisdas]

simply try to check if

column=trim(col umn)

i think you are not trying to findout space inbetween chars.