oracle
iteye_21091
这个作者很懒,什么都没留下…
展开
-
Oracle 删除数据库中所有的对象
[code="sql"]create or replaceFUNCTION DROP_ALL_SCHEMA_OBJECTS RETURN NUMBER ASPRAGMA AUTONOMOUS_TRANSACTION;cursor c_get_objects is select object_type,'"'||object_name||'"'||...原创 2014-02-21 14:40:00 · 603 阅读 · 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 t2. base64 的加密函数select utl_raw.cast_to_varchar2(utl_encode.base64_encod...原创 2014-05-17 10:26:38 · 459 阅读 · 0 评论