Hi guys, i have a question for you. i want to convert number value to xxxx in sql. i mean select data_length from dba_tab_cols where owner='SCOTT' and table_name='TEST'; it will return 9. but i want to return XXXXXXXX. i mean result-1 if 7. then. XXXXXX if 5 then XXXX is it possible?