Oracle Database Discussions

I am using oracle Release 9.2.0.7.0 and I am trying to access a database containing telephone numbers and codes, the table contains two columns with the names no and code both are VARCHAR2 column datatype. As you can see below the values in these two columns are ASCII characters and symbols. I tried to save the SQLPLUS query (select no, code from subdata) into a a file using spool command but the Ascii symbols and characters have being changed into some other format I am not familiar with I will show it below. Therefore is there a function that can help me to convert the ascii codes into the telephone numbers without doing any import or export, an embedded SQLPlus function will help me very much.

This is a sample of the current table containing the ASCII codes:


no code
-------- --------
%)öFƒ   cs☺ ☻YO
%)ûe_   cs☺ ☻Y_
%)ö►_   cs☺ ☻Y
%)ö♥▼   cs☺ ☻YÅ
%)ö"_   cs☺ ☻Yƒ
%)ö☻o   cs☺ ☻`
%)ô☺▼   cs☺ ☻`▼
%)öt_   cs☺ ☻`/
%)öto   cs☺ ☻`?
%)æ_   cs☺ ☻a
%)òS▼   cs☺ ☻h_

no code
-------- --------
%)öv   cs☺ ☻pÅ
%)öp?   cs☺ ☻pƒ
%)Æ♠_   cs☺ ☻q
%)öp/   cs☺ ☻q▼
%)öuo   cs☺ ☻q/
%)Æ _   cs☺ ☻q?
%)ö↨O   cs☺ ☻qƒ
%)öu   cs☺ ☻r
%)ÿ☺O   cs☺ ☻r▼
%)öQ_   cs☺ ☻r/
%)öB?   cs☺ ☻r?

24 rows selected.

SQL>


This is the format I got after I saved the query results of the sub_data table into a text file using SPOOL command:


no Code
-------- --------
%)^G\2223?\377\377 cs 5_

%)^G\225^X_\377\377 cs 5\217

%)^G\2238\217\377\377 cs 3/

%)^G\225^Q\217\377\377 cs 6O

%)^G\223^Q^O\377\377 cs 3?

%)^G\223SO\377\377 cs 3o

%)^G\2231^O\377\377 cs 3^?

%)^G\223\225/\377\377 cs 3\217

%)^G\223^W^_\377\377 cs 3\237

Abdel Moalim

Bosaso, Somalia