Total Beginner Question..or two

[Raminder]

You can use the substr function in oracle and build upon it. You can either make your own function, your build a select statement directly,
viz : select '('||substr(phone, 2,4)||')' from phone_table;