142.4.12 SHOW_ENDPOINTS Function

The SHOW_ENDPOINTS functions returns all endpoints as a JSON list.

Syntax

DBMS_OBSERVABILITY.SHOW_ENDPOINTS;

Usage Notes

The SHOW_ENDPOINTS function returns a CLOB containing a JSON array as follows:

[{"Id":Endpoint's id,"Type":"Endpoint's type","Endpoint":"URL", "Status":"Enabled or Disabled","Credential":"Credential's name or None"}]

Examples

The following example illustrates how to show all endpoints:

set serveroutput on;
DECLARE
  v_endpoints CLOB;
BEGIN
  select dbms_observability.show_endpoints into v_endpoints;

  dbms_output.put_line( v_endpoints );
END;
/