Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting data in Hexadecimal mode

569049Mar 28 2007 — edited Mar 28 2007
Please

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2007
Added on Mar 28 2007
2 comments
897 views