Oracle ORDS的简单SQL配置模板

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;

改天慢慢完善.