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

Home -> Community -> Usenet -> c.d.o.server -> casting into hex?

casting into hex?

From: Aakash Bordia <a_bordia_at_hotmail.com>
Date: Wed, 5 Feb 2003 11:07:10 -0800
Message-ID: <b1rnhc$g3i$1@hanover.torolab.ibm.com> 





Hello, How can I cast a string like 'abc' to hex and insert it into a raw
column.



eg: insert into table1 select raw(hex('abc')) from table2



How do I accomplish this in SQL ?



I cannot use procedural SQL here.


Thanks


Aakash
Received on Wed Feb 05 2003 - 13:07:10 CST












Original text of this message













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