Once again Thank you Raminder Just thought I would post what I did to the code that Raminder explained to me for a simple table called contacts

create table contacts (
First_Name varchar2 (15),
Last_Name varchar2 (15),
Phone varchar2 (10));

insert into contact values
('John', 'Doe', '1234567890');

then to view them i did this


select '('||substr(phone, 1,3)||')' "AREA",
''||substr(phone, 4,3)||'-'||substr(phone, 7,4)||'' "PHONE" from contact;

And it works great in the PL/SQL viewer that I did the code into. I know lots of people are wanting to know this so here it is.


Just making my first contribution in this forum.