将小巧的Oracle长原始值转换为其他类型 [英] Converting small-ish Oracle long raw values to other types

问题描述

我有一个Oracle表，其中包含LONG RAW类型的字段，该字段包含ASCII字符数据.如何编写查询或视图，将其转换为更容易使用的字符串?这些总是FWIW单字节字符.

I have an Oracle table that contains a field of LONG RAW type that contains ASCII character data. How can I write a query or view that will convert this to a more easily consumed character string? These are always going to be single-byte characters, FWIW.

推荐答案

也许

select ...., to_lob(long_raw) from old_table

( http://www.psoug.org/reference/convert_func.html)

或

UTL_RAW.CAST_TO_VARCHAR2(b) 

( http://www.dbasupport.com/forums/showthread. php?t = 5342 ).

这篇关于将小巧的Oracle长原始值转换为其他类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！