SQL Query

 Hi ,

We are using Oracle 10.2.0.3.0.We have a table and it's having one column called PHNUM.It is having records as follws.

PHNUM

-------------------

3214558500

3214558505

3214558550

3214558555

32145698789

32148976577

.......

.....

Required O/P is : 

Step 1:   I want to write a query to get the O/P as folows by uisng SUBSTR   function only. (please let me know  another way of query as well)   3214558500-3214558505||3214558550||3214558555||3214569878||3214897657 3214558500-3214558505||3214558550||3214558555||3214569878||3214897657 Step 2: After completing Step1 I want o to write 2nd query to display the O/P as follows.   014/55.85.00||014/55.85.05||014/55.85.50||014/55.85.55               (or) 014/55.85.00-014/55.85.05||014/55.85.50||014/55.85.55 (by using SUBSTR ) and (another way as well)

can any one please let me know the way to write a query for this.

 Thank you,