<bdo id='PZUSe'></bdo><ul id='PZUSe'></ul>
  • <legend id='PZUSe'><style id='PZUSe'><dir id='PZUSe'><q id='PZUSe'></q></dir></style></legend>

        <small id='PZUSe'></small><noframes id='PZUSe'>

      1. <tfoot id='PZUSe'></tfoot>
      2. <i id='PZUSe'><tr id='PZUSe'><dt id='PZUSe'><q id='PZUSe'><span id='PZUSe'><b id='PZUSe'><form id='PZUSe'><ins id='PZUSe'></ins><ul id='PZUSe'></ul><sub id='PZUSe'></sub></form><legend id='PZUSe'></legend><bdo id='PZUSe'><pre id='PZUSe'><center id='PZUSe'></center></pre></bdo></b><th id='PZUSe'></th></span></q></dt></tr></i><div id='PZUSe'><tfoot id='PZUSe'></tfoot><dl id='PZUSe'><fieldset id='PZUSe'></fieldset></dl></div>

        PL/SQL 中有散列函数吗?

        Is there any hash function in PL/SQL?(PL/SQL 中有散列函数吗?)
        • <bdo id='Bt2Oo'></bdo><ul id='Bt2Oo'></ul>

          <small id='Bt2Oo'></small><noframes id='Bt2Oo'>

            • <i id='Bt2Oo'><tr id='Bt2Oo'><dt id='Bt2Oo'><q id='Bt2Oo'><span id='Bt2Oo'><b id='Bt2Oo'><form id='Bt2Oo'><ins id='Bt2Oo'></ins><ul id='Bt2Oo'></ul><sub id='Bt2Oo'></sub></form><legend id='Bt2Oo'></legend><bdo id='Bt2Oo'><pre id='Bt2Oo'><center id='Bt2Oo'></center></pre></bdo></b><th id='Bt2Oo'></th></span></q></dt></tr></i><div id='Bt2Oo'><tfoot id='Bt2Oo'></tfoot><dl id='Bt2Oo'><fieldset id='Bt2Oo'></fieldset></dl></div>
              <legend id='Bt2Oo'><style id='Bt2Oo'><dir id='Bt2Oo'><q id='Bt2Oo'></q></dir></style></legend>

                  <tbody id='Bt2Oo'></tbody>
                <tfoot id='Bt2Oo'></tfoot>

                  本文介绍了PL/SQL 中有散列函数吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我正在 PL/SQL 中寻找哈希函数,以获取 varchar 的哈希.我在 Oracle 10 中找到了一个名为 dbms_crypto 的包,其中包含一个函数 dbms_crypto.hash 甚至其他包 dbms_sqlhash.getHash,但是在我调用它们的地方,我收到一条消息,就像它找不到它们一样......

                  I'm looking for a Hash function in PL/SQL, to get the hash of a varchar. I found a package in Oracle 10 called dbms_crypto with a function dbms_crypto.hash and even other package dbms_sqlhash.getHash, however where I called them, I've got a message like it cannot find them...

                  有人知道我怎么称呼他们吗??还有其他包吗?

                  Does somebody know how can I call them?? Is there any other package?

                  这是我的代码

                  DECLARE
                   l_textToHash VARCHAR2(19) := 'toto123';
                   l_ccn_raw RAW(128) := utl_raw.cast_to_raw(l_textToHash);
                   l_encrypted_raw RAW(2048);
                  BEGIN
                    dbms_output.put_line('CC:  ' || l_ccn_raw);
                    l_encrypted_raw := dbms_crypto.hash(l_ccn_raw, 3);
                    dbms_output.put_line('SH1: ' || l_encrypted_raw);
                  END;
                  /
                  

                  这是消息

                  Error starting at line 1 in command:
                  DECLARE
                   l_textToHash VARCHAR2(19) := 'toto123';
                   l_ccn_raw RAW(128) := utl_raw.cast_to_raw(l_textToHash);
                   l_encrypted_raw RAW(2048);
                  BEGIN
                    dbms_output.put_line('CC:  ' || l_ccn_raw);
                    l_encrypted_raw := dbms_crypto.hash(l_ccn_raw, 3);
                    dbms_output.put_line('SH1: ' || l_encrypted_raw);
                  END;
                  Error report:
                  ORA-06550: line 7, column 22:
                  PLS-00201: identifier 'DBMS_CRYPTO' must be declared
                  ORA-06550: line 7, column 3:
                  PL/SQL: Statement ignored
                  06550. 00000 -  "line %s, column %s:
                  %s"
                  *Cause:    Usually a PL/SQL compilation error.
                  *Action:
                  

                  谢谢!

                  推荐答案

                  确保您已向与之连接的用户授予适当的权限.与您的 DBA 联系以添加对 SYS.DBMS_CRYPTO 包的执行权限.

                  Make sure that you have the appropriate permissions granted to the user that you are connecting with. Talk to your DBA to add the execute permission on the SYS.DBMS_CRYPTO package.

                  Oracle 提供了一个很好的指南 使用 oracle 数据库处理散列和加密数据.

                  Oracle provides a nice guide on working with hashed and encrypted data using the oracle database.

                  如果您使用的是不支持 DBMS_CRYPTO 的旧版本数据库,您也可以尝试 DBMS_OBFUSCATION_TOOLKIT.

                  If you are on an older version of the database that doesn't support DBMS_CRYPTO, you can also try DBMS_OBFUSCATION_TOOLKIT.

                  在 Oracle 12c 中,您可以使用函数 STANDARD_HASH.

                  In Oracle 12c you can use the function STANDARD_HASH.

                  这篇关于PL/SQL 中有散列函数吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  How to redirect the output of DBMS_OUTPUT.PUT_LINE to a file?(如何将 DBMS_OUTPUT.PUT_LINE 的输出重定向到文件?)
                  How do I get column datatype in Oracle with PL-SQL with low privileges?(如何使用低权限的 PL-SQL 在 Oracle 中获取列数据类型?)
                  Get a list of all functions and procedures in an Oracle database(获取 Oracle 数据库中所有函数和过程的列表)
                  Why cannot I create triggers on objects owned by SYS?(为什么我不能在 SYS 拥有的对象上创建触发器?)
                  Returning result even for elements in IN list that don#39;t exist in table(即使对于表中不存在的 IN 列表中的元素也返回结果)
                  Reset Sequence in oracle 11g(oracle 11g 中的重置序列)
                  • <i id='FKFTn'><tr id='FKFTn'><dt id='FKFTn'><q id='FKFTn'><span id='FKFTn'><b id='FKFTn'><form id='FKFTn'><ins id='FKFTn'></ins><ul id='FKFTn'></ul><sub id='FKFTn'></sub></form><legend id='FKFTn'></legend><bdo id='FKFTn'><pre id='FKFTn'><center id='FKFTn'></center></pre></bdo></b><th id='FKFTn'></th></span></q></dt></tr></i><div id='FKFTn'><tfoot id='FKFTn'></tfoot><dl id='FKFTn'><fieldset id='FKFTn'></fieldset></dl></div>
                      • <bdo id='FKFTn'></bdo><ul id='FKFTn'></ul>

                          <tbody id='FKFTn'></tbody>

                            <tfoot id='FKFTn'></tfoot><legend id='FKFTn'><style id='FKFTn'><dir id='FKFTn'><q id='FKFTn'></q></dir></style></legend>
                          1. <small id='FKFTn'></small><noframes id='FKFTn'>