add

About Me

My photo
Oracle Apps - Techno Functional consultant

Wednesday, June 13

Convert number to characters..

select USER_ID  ,   (TO_CHAR (TO_DATE(USER_ID,'j'), 'Jsp'))   user_id_string
from FND_USER where USER_NAME = 'JKUMAR'  ;

No comments: