Inserting data in Hexadecimal mode
569049Mar 28 2007 — edited Mar 28 2007Please
I have a question about Inserting data in Hexadecimal mode:
that's my table:
CREATE TABLE STAB (
TYTABL varchar(1) default '' NOT NULL,
CLTABL varchar(4) default '' NOT NULL,
CDTABL varchar(30) default '' NOT NULL,
DTFEFF char(8) default NULL
);
In MySql or DB2, i can use this insert query to insert data:
INSERT INTO STAB (TYTABL, CLTABL, CDTABL, DTFEFF) VALUES(x'31', x'20204145', x'202A20404040202B20656263', x'20407F')
This insert query doesn't work in the ORACLE.
Is there a method i can use to insert data in hexadecimal mode in ORACLE???.
Thanx