Oracle ORDS使用SQL Developer发布Webservice

最新推荐文章于 2025-06-28 19:10:47 发布

原创

最新推荐文章于 2025-06-28 19:10:47 发布 · 8.2k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#APEX

本文介绍如何通过SQL Developer启用Oracle数据库的ORDS服务，为模式和对象创建REST服务，以及进行ORDS管理和使用SQLcl命令操作REST模块。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Assumptions and Comments

This article assumes the following.

You already have a functioning installation of ORDS.
The paths for the ORDS configuration match those from the ORDS installation article listed above.
You have an Oracle database available. In this article I will be using a 12c database, but it works just the same with an 11g database.
You have a way to call the web services. Some GET web services can be called from a browser, but the other methods require some coding, or a REST client. I used "curl" and the "Advanced REST client" extension for Chrome.
You already have an understanding of the various pieces of ORDS functionality. This article will not teach you about this, but the linked articles will.

Enable ORDS for a Schema

Right-click on the connection and select the "REST Services > Enable REST Services..." menu option.

Enable ORDS for a Schema : Menu

Check the "Enable schema" checkbox and alter the schema alias if you don't want to expose the schema name in the URL. In this case we will ignore authorization. Click the "Next >" button.

Enable ORDS for a Schema : Specify Details 1