Phone Format

[abc]

Hi Szhark.
check this one.

select 'New Phone Number - ('||
substr(to_char(PHONE_NUM,'0999999999'),2,3)||') '||
substr(to_char(PHONE_NUM,'0999999999'),5,3)||' - '||
substr(to_char(PHONE_NUM,'0999999999'),8,4)
from YOUR_TABLE;

Thanks
ABC