<mmf.stavelot (AT) gmail (DOT) com> wrote

Jim

On Oct 3, 6:47*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
If you are going to try to work with bits via Oracle you might find
the following SQL functions of interest:

HEXTORAW
RAWTOHEX
BITAND
BIN_TO_NUM

as well as the functions provided by the UTL_RAW package.

HTH -- Mark D Powell --

On Oct 3, 6:47*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
If you are going to try to work with bits via Oracle you might find
the following SQL functions of interest:

HEXTORAW
RAWTOHEX
BITAND
BIN_TO_NUM

as well as the functions provided by the UTL_RAW package.

HTH -- Mark D Powell --

On Oct 3, 6:47*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
If you are going to try to work with bits via Oracle you might find
the following SQL functions of interest:

HEXTORAW
RAWTOHEX
BITAND
BIN_TO_NUM

as well as the functions provided by the UTL_RAW package.

HTH -- Mark D Powell --

On Oct 3, 6:47*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
If you are going to try to work with bits via Oracle you might find
the following SQL functions of interest:

HEXTORAW
RAWTOHEX
BITAND
BIN_TO_NUM

as well as the functions provided by the UTL_RAW package.

HTH -- Mark D Powell --

Mark D Powell wrote:
Don't forget:
NUMTOHEX
NUMTOHEX2
and
RAWTONHEX
http://www.psoug.org/reference/builtin_functions.html
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Mark D Powell wrote:
Don't forget:
NUMTOHEX
NUMTOHEX2
and
RAWTONHEX
http://www.psoug.org/reference/builtin_functions.html
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Mark D Powell wrote:
Don't forget:
NUMTOHEX
NUMTOHEX2
and
RAWTONHEX
http://www.psoug.org/reference/builtin_functions.html
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Mark D Powell wrote:
Don't forget:
NUMTOHEX
NUMTOHEX2
and
RAWTONHEX
http://www.psoug.org/reference/builtin_functions.html
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Oct 3, 5:47*am, "gym dot scuba dot kennedy at gmail"
<kenned... (AT) verizon (DOT) net> wrote:
Actually nothing stops you from inserting nonprintable ascii
characters in a VARCHAR2 column.
[Speaking from the experience of an ASCII nul (0) inserted in VARCHAR2
by a C program.]

I have a table badlog with column
last_line VARCHAR2(100);

insert into badlog values ('eee'||chr(1)||chr(5)||'ddd') ;

SELECT * from badlog;

LAST_LINE
--------------------
eee<01><05>ddd --- modified to not post binary 01 and 05 in case
that


1 row selected.

select rawtohex(last_line) from badlog ;
RAWTOHEX(LAST_LINE)
--------------------------------
6565650105646464 --- you can see they are real binary values.


1 row selected.

I would not recomend this, but it works. Displaying the result will
depend heavily on your character set.
Ed