带小数点的字符串（除小数点外其它的都是数字）转换成数值 TO_NUMBER Converts a string to the NUMBER data type TO_NUMBE
带小数点的字符串（除小数点外其它的都是数字）转换成数值
TO_NUMBER
Converts a string to the NUMBER data typeTO_NUMBER([, , ]) RETURN NUMBER
CREATE TABLE test (
testcol VARCHAR2(10));
INSERT INTO test VALUES (‘12345.67’);
SELECT TO_BINARY_DOUBLE(testcol) BIN_DOUBLE, TO_BINARY_FLOAT(testcol) BIN_FLOAT, TO_NUMBER(testcol) NMBR
FROM test;
Converts a HEX number to FLOATTO_NUMBER(, );
SELECT TO_NUMBER(‘0A’, ‘XX’)
FROM dual;
Converts a HEX number to DECIMALTO_NUMBER(,
”) RETURN ;
SELECT TO_NUMBER(100000,’XXXXXXXX’)
FROM dual;
1.语法：to_number(string[,format[,nlsparams]])
目的：将char或varchar2类型的string转换为一个number类型的数值，，如果指定了format,那么string应该遵循相应的数字格式。
2.范例
declare
v_num number;
begin
v_num := to_number( ‘$12345.67 ‘, ‘$99999.99 ‘);
end;
Oracle UTL_RAW
General Information
Source{ORACLE_HOME}/rdbms/admin/utlraw.sql
First Available7.3.4
Constants
NameData TypeValue
Dependencies179 objects
SELECT name FROM dba_dependencies
WHERE referenced_name = ‘UTL_RAW’
UNION
SELECT referenced_name FROM dba_dependencies
WHERE name = ‘UTL_RAW’;
Exceptions
Error #NameDescription
An arithmetic, conversion, truncation, or size-constraint error. Usually raised by trying to cram a 6 character string into a VARCHAR2(5).
Required Object PrivilegesGRANT execute on UTL_RAW
GRANT execute ON utl_raw TO UWCLASS;
BIT_AND
Perform bitwise logical “and” of the values in raw r1 with raw r2 and return the “anded” result rawutl_raw.bit_and(r1 IN RAW, r2 IN RAW) RETURN RAW;
SELECT utl_raw.bit_and(‘0102F3’, ‘F30201’)
FROM dual;
BIT_COMPLEMENT
Perform bitwise logical “complement” of the values in raw and return the “complement’ed” result rawutl_raw.bit_complement(r IN RAW) RETURN RAW;
SELECT utl_raw.bit_complement(‘0102F3’)
FROM dual;
BIT_OR
Perform bitwise logical “or” of the values in raw r1 with raw r2 and return the “or’d” result rawutl_raw.bit_or(r1 IN RAW, r2 IN RAW) RETURN RAW;
SELECT utl_raw.bit_or(‘0102F3’, ‘F30201’)
FROM dual;
BIT_XOR
Perform bitwise logical “exclusive or” of the values in raw r1 with raw r2 and return the “xor’d” result rawutl_raw.bit_xor(r1 IN RAW, r2 IN RAW) RETURN RAW;
SELECT utl_raw.bit_xor(‘0102F3’, ‘F30201’)
FROM dual;
CAST_FROM_BINARY_DOUBLE
Return the RAW representation of a binary_double valueutl_raw.cast_from_binary_double(n IN BINARY_DOUBLE,
endianess IN PLS_INTEGER DEFAULT 1) RETURN RAW;
SELECT utl_raw.cast_from_binary_double(123.45)
FROM dual;
CAST_FROM_BINARY_FLOAT
Return the RAW representation of a binary_float valueutl_raw.cast_from_binary_float(n IN BINARY_FLOAT,
endianess IN PLS_INTEGER DEFAULT 1) RETURN RAW;
SELECT utl_raw.cast_from_binary_float(123.45)
FROM dual;
CAST_FROM_BINARY_INTEGER
Return the RAW representation of a binary_integer valueutl_raw.cast_from_binary_integer(
n IN BINARY_INTEGER,
endianess IN PLS_INTEGER DEFAULT 1) RETURN RAW;
SELECT utl_raw.cast_from_binary_integer(100)
FROM dual;
CAST_FROM_NUMBER
Returns the binary representation of a NUMBER in RAWutl_raw.cast_from_number(n IN NUMBER) RETURN RAW;
SELECT utl_raw.cast_from_number(100)
FROM dual;
CAST_TO_BINARY_DOUBLE
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至253000106@qq.com举报，一经查实，本站将立刻删除。
发布者：PHP中文网，转转请注明出处：https://www.chuangxiangniao.com/p/1951592.html
