對(duì)Oracle Raw類型的詳細(xì)解剖
Jun 07, 2016 pm 03:51 PM
SQL create table datatype_test_raw(paddr raw(8)); Table created SQL insert into datatype_test_raw(paddr) values(utl_raw.cast_to_raw('This is a raw type test!')); insert into datatype_test_raw(paddr) values(utl_raw.cast_to_raw('This is a raw
SQL> create table datatype_test_raw(paddr raw(8));Table created
SQL> insert into datatype_test_raw(paddr) values(utl_raw.cast_to_raw('This is a raw type test!'));
insert into datatype_test_raw(paddr) values(utl_raw.cast_to_raw('This is a raw type test!'))
ORA-01401: inserted value too large for column
SQL> alter table datatype_test_raw modify paddr raw(20);
Table altered
SQL> insert into datatype_test_raw(paddr) values(utl_raw.cast_to_raw('This is a raw type test!'));
insert into datatype_test_raw(paddr) values(utl_raw.cast_to_raw('This is a raw type test!'))
ORA-01401: inserted value too large for column
SQL> insert into datatype_test_raw(paddr) values(utl_raw.cast_to_raw('This is a raw test!'));
1 row inserted
SQL> commit;
Commit complete
SQL> select * from datatype_test_raw;
PADDR
----------------------------------------
54686973206973206120726177207465737421
SQL> select utl_raw.cast_to_varchar2(paddr) from datatype_test_raw;
UTL_RAW.CAST_TO_VARCHAR2(PADDR
--------------------------------------------------------------------------------
This is a raw test!
SQL> insert into datatype_test_raw(paddr) values(utl_raw.cast_to_raw('中文測(cè)試'));
1 row inserted
SQL> commit;
Commit complete
SQL> select utl_raw.cast_to_varchar2(paddr) from datatype_test_raw;
UTL_RAW.CAST_TO_VARCHAR2(PADDR
--------------------------------------------------------------------------------
This is a raw test!
中文測(cè)試
SQL> select paddr, utl_raw.cast_to_varchar2(paddr) from datatype_test_raw;
PADDR UTL_RAW.CAST_TO_VARCHAR2(PADDR
---------------------------------------- --------------------------------------------------------------------------------
54686973206973206120726177207465737421 This is a raw test!
D6D0CEC4B2E2CAD4 中文測(cè)試
這里用到了兩個(gè)函數(shù)：
utl_raw.cast_to_raw([varchar2]);--將varchar2轉(zhuǎn)換為raw類型
utl_raw.cast_to_varchar2([raw]);--將raw轉(zhuǎn)換為varchar2類型
這里varchar2的字符集一般是GB2312。
另外：
utl_raw包的幾個(gè)其他的函數(shù)用法：
utl_raw.cast_from_number([number]);
utl_raw.cast_to_number([number]);
位操作：
utl_raw.bit_or();
utl_raw.bit_and();
utl_raw.bit_xor();
另外還有轉(zhuǎn)換函數(shù)：
hextoraw(); --將對(duì)應(yīng)16進(jìn)制數(shù)轉(zhuǎn)換為raw
當(dāng)使用HEXTORAW時(shí)，會(huì)把字符串中數(shù)據(jù)當(dāng)作16進(jìn)制數(shù)。而使用UTL_RAW.CAST_TO_RAW時(shí)，直接把字符串中每個(gè)字符的ASCII碼存放到RAW類型的字段中
? AI ??
Undress AI Tool
??? ???? ??
Undresser.AI Undress
???? ?? ??? ??? ?? AI ?? ?
AI Clothes Remover
???? ?? ???? ??? AI ?????.
Clothoff.io
AI ? ???
Video Face Swap
??? ??? AI ?? ?? ??? ???? ?? ???? ??? ?? ????!
?? ??
??? ??
???++7.3.1
???? ?? ?? ?? ???
SublimeText3 ??? ??
??? ??, ???? ?? ????.
???? 13.0.1 ???
??? PHP ?? ?? ??
???? CS6
??? ? ?? ??
SublimeText3 Mac ??
? ??? ?? ?? ?????(SublimeText3)
???? ???? ???? (ICNT) ? ?????? ???? Binance? ? ?? ? ICN ????? ?? ??? ? ??
Jul 07, 2025 pm 07:06 PM
?? 1. ICN?? ?????? 2. ICNT ?? ???? 3. ICN? ?? Depin ???? ? ?? ?? ?? ?? ? ???? ?? 4. 5 ? ? Depin ??? ?? ??? ?? ICN (INCEBLECLOUDNETWORK) @ICN_Protocol? NGPCAPITAL? ?? ??? ??? 4,700 ? ??? ??? ???? ??????. ?? ???? ? ??? "Xiaomi? Web3? ?? ?????" ??? Lei Jun? ???? ???? ???? Xiaomi, Helium ? Workfusion? ?? ? ??
Oracle? REDO ? UNDO ????? ???? ?? ? ??? ??? ??????
Jul 08, 2025 am 12:16 AM
OracleNsuresTransactionDurabilityandconsistencysingedoforcommitsandundoforrollbacks.duringAcommit, OracleGenerateCommitrecordintheredologorbuffer, Markschangespermanentinredologs ? andupdateshescntoreflectthecurrentDatabasestate.forrollbacks
JavaScript Time Object, ??? Google Chrome? EACTEXE, ? ?? ? ???? ?????.
Jul 08, 2025 pm 02:27 PM
?????, JavaScript ???! ?? ? JavaScript ??? ?? ?? ?????! ?? ?? ??? ??? ??? ? ????. Deno?? Oracle? ?? ??, ??? JavaScript ?? ??? ????, Google Chrome ???? ? ??? ??? ???? ?????. ?????! Deno Oracle? "JavaScript"??? ????? Oracle? ?? ??? ??? ??????. Node.js? Deno? ??? ? Ryan Dahl? ??? ?????? ???? ????? JavaScript? ??? ???? Oracle? ????? ???? ?????.
Oracle? ???? ??? ????, ??? ? ??? ??????
Jul 13, 2025 am 12:52 AM
Oracle? ?? ?? ?? ?? ??? ???? ????? ?? ?? ??? ?? ?? ???? ??? ???? ??? ??? ?? ?? ??? ??? ? ????. ?? ????? ?????? ?????? NLS_LANG ??? ???? ??? ?? ?????? ?? ?? convert () ??? ???? ??? ?? ??? ??? ?? ?? ??? ???? ????. ?? ?? ??? ??? ????. 1. Al32UTF8? ?? ??? ???? ?? ??? ?????? ??? ??????. 2. ????? NLS_LANG? ???? ?????. 3. NVARCHAR2 ? NCLOB? ???? ??? ???? ??????. 4. CSSCAN ??? ???? ?????? ?? ??? ??? ??????. 5. ?? (), substr () ? ?? ??? ??????
??? Oracle ???????? ??? ?? ??? ??? ???????
Jul 05, 2025 am 01:22 AM
Oracle ???????? ??? ??? ?? ??? ????? ???? ???? ???? ??? ?? ??? ????? ????. ?? ???? ??? ?????. 1. ?? ??? ??????. DBA? ????? ??? ??? ??? ?? ? ??? ??? ?? ??? ?? ? ??? ???? ??? ????? ?????. 2. ?? ??? ??? ??? ???? ?? ??? ?? ?? ???? ????? ?? ?? ???? ? ???? ?? ?? ? ??? ??? ????. 3. ?? ?? ? ?? ? ??? ???? ?? ?? ???, ?? ? ?? ?? ? ?? ??? ???? ??? ? ?? ???? ??????. ??? ??? ??? ?????? ???? ????? ???? ?????? ?? ?????.
?? ???? ??? ??? ?? ? ???? ??? ??? ??????
Jul 11, 2025 am 01:51 AM
SQL? CreateTable ? ? ??? ???? ?? ???? ??? ??? ???? ?? ? ????. ?? ??? ??? ????. 1. CreateTableNew_tableAsselect*fromexisting_tablewhere1 = 0;? ???? ? ???? ????. 2. ??? ???? ?? ??? ??? ????? ???? ?? ??? ?? ???, ?? ?, ??? ?? ???? ??????.
SQL? ????? ? ???? ? ???? ???? ??????
Jul 04, 2025 am 03:03 AM
ClusteredAndnon-clusteredEdexesDexesDifferIndataOrganizationAndusage.1.ClusteredEdexesDefinEthePhysicalOderOfDatastorage, ??, ???, ???? forrangequeries.2.non-clusteDexeScreateScreateSparatestructureWithpointerStodatArows, enablingmultiplei
Fragmetric (Frag)?? ?????? ???? ?? ?? ?? ? ?? ??? ??
Jul 07, 2025 pm 07:27 PM
???? ??? (??)?? ?????? Fragmetric? Frag Tokens? ??? Fragmetric? ?? ??? ?????? 1. ???? ??? ?? ?? ??? 2. ??? ?? ??? 3. ??? ?? ??? 4. ???? ???? ?? ?? ?? ?? ??? ?? ?? ? ??? ??? ?? ?? ???? 1. FRAG-22 ?? ?? ?? 2. ??? ? ??? ?? ?? 3. NCN ?? ???? 4. ?? ?? ?? ?? FR.
