Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to reveal hidden codes

Re: How to reveal hidden codes

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 6 Feb 2005 12:57:34 -0800
Message-ID: <420684be@news.victoria.tc.ca>


cschang (cschang_at_maxinter.net) wrote:
: I am not a frequent user of oracle programmer. I remember seeing the
: solution about four years ago and I can not find from my memory and from
: the web. I will appreciate if anyone can help. What I have is one
: varchar2 column containing text records as 'No comment.'. I want to use
: the DECODE(val, 'No comment.', '', val) to display the empty or other
: kinds of text. But it won't work. Hence, I used the length function to
: check on the No comment. value in the column and did return as 11. I
: remember there was a function I can display the binary code of every
: character of the data in the field. I also manually checked such value
: with
: SQL>exec :str:='No comment.';
: execution successfully

: SQL>select DECODE(:str, 'No comment.', '', :str) comments from dual;
: -----------------------------------------------------------

: I am using 9 R2 on Windows 2K. Thanks.

To display "binary" data in a character string, google "oracle character function". It returns references to things like the "dump" function, plus many others.

--

This space not for rent.
Received on Sun Feb 06 2005 - 14:57:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US