Query layer parameter docs — Provide Oracle SQL examples for view_extent and view_scale

[Bud]

Regarding the query layer parameter documentation:

There are SQL Server and PostgreSQL examples in the docs for view_extent and view_scale. Could Oracle examples be added too?

view_extent

• In SQL Server: WHERE shape.STWithin(geometry::STGeomFromText(::view_extent, 4326)) = 1
• In PostgreSQL: WHERE ST_Within(shape, ST_GeomFromText(::view_extent, 4326))

view_scale

• In SQL Server: WHERE IIF(::view_scale > 100000, <do this>, <do that>)
• In PostgreSQL: WHERE (CASE WHEN ::view_scale >= 100000 THEN <do this> WHEN ::view_scale >= 50000 AND ::view_scale < 100000 THEN <do that> ELSE <do the other thing> END)

@MarceloMarques or @TanuHoque might have some insight.