Oracle ORDS的简单SQL配置模板 -云博客

Oracle ORDS的简单SQL配置模板

# 数据库 2024-05-05 20:26 0 50 来源：云博客

1. 先加上简单的SQL配置模板.

DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN ORDS.ENABLE_SCHEMA(p_enabled => TRUE, p_schema => ‘LCOI709999‘, p_url_mapping_type => ‘BASE_PATH‘, p_url_mapping_pattern => ‘lcoi709999‘, p_auto_rest_auth => FALSE); commit;END;DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN ORDS.ENABLE_OBJECT(p_enabled => TRUE, p_schema => ‘LCOI709999‘, p_object => ‘ZWKMZD2017‘, p_object_type => ‘TABLE‘, p_object_alias => ‘ZWKMZD2017‘, p_auto_rest_auth => FALSE); commit;END;