-- -----------------------------------------------------------------------------------
-- File Name    : dba_ords_schemas.sql
-- Author       : DBA Learning Hub
-- Description  : Displays all ORDS enabled schemas.
-- Call Syntax  : @dba_ords_schemas
-- Last Modified: 15/07/2025
-- -----------------------------------------------------------------------------------
set linesize 100
column parsing_schema format a20
column pattern format a30
column status format a10

select id,
       parsing_schema,
       pattern,
       status
from   dba_ords_schemas
order by parsing_schema;