![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
iteye_21091
这个作者很懒,什么都没留下…
展开
-
Oracle 删除数据库中所有的对象
[code="sql"] create or replace FUNCTION DROP_ALL_SCHEMA_OBJECTS RETURN NUMBER AS PRAGMA AUTONOMOUS_TRANSACTION; cursor c_get_objects is select object_type,'"'||object_name||'"'||...原创 2014-02-21 14:40:00 · 555 阅读 · 1 评论 -
oracle里面base64加解密
1. base64 的解密函数 select utl_raw.cast_to_varchar2(utl_encode.base64_decode(utl_raw.cast_to_raw(t.claim_id))) from t_claim t 2. base64 的加密函数 select utl_raw.cast_to_varchar2(utl_encode.base64_encod...原创 2014-05-17 10:26:38 · 426 阅读 · 0 评论