维护常用语句

[[Oracle APEX]]

切换后台工作区的认证方式

场景:
当后台工作区的认证切换成其他后, 不能使用时可通过以下语句切换成默认apex的登录方式.

1
2
3
4


BEGIN
    apex_instance_admin.set_parameter('APEX_BUILDER_AUTHENTICATION', 'APEX');
    COMMIT;
END;

db账号启用Ords的 Database Actions(原名SQL Developer Web)

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13



CREATE USER XIN IDENTIFIED BY "T12vegCqDQrgXJ2j64";
GRANT CREATE SESSION TO XIN;
-- ALTER USER  ni_shuting0101  IDENTIFIED BY "?Hp7:v!3?E31eF?." REPLACE "T12vegCqDQrgXJ2j64"
-- 启用 ords web 登录
BEGIN
    ords_admin.enable_schema(
            p_enabled => TRUE,
            p_schema => 'XIN'
    );
    COMMIT;
END;
drop  user XIN CASCADE ;

json解析

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15



SELECT JSON_VALUE(q'! {
  "errcode": 0,
  "result": {
    "associated_unionid": "N2o5U3axxxx",
    "unionid": "gliiW0piiii02zBUjUxxxx",
    "device_id": "12drtfxxxxx",
    "sys_level": 1,
    "name": "张xx",
    "sys": true,
    "userid": "userid123"
  },
  "errmsg": "ok"
}!', '$.result.unionid' RETURNING varchar2(100))
FROM DUAL;

ps/sql

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12



DECLARE
    je JSON_ELEMENT_T;
    jo JSON_OBJECT_T;
BEGIN
    je := JSON_ELEMENT_T.parse('{"name":"Radio controlled plane"}');
    IF (je.is_Object) THEN
        jo := TREAT(je AS JSON_OBJECT_T);
        jo.put('price', 149.99);
    END IF;
    DBMS_OUTPUT.put_line(je.to_string);
END;

DB更新密码

1

ALTER USER  用户名  IDENTIFIED BY "新密码" REPLACE "旧密码";