Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Idea: Update the docs - Table() function is unnecessary when using GetVertices()

User_1871Jun 12 2022 — edited Jun 12 2022

The Table() function appears to be unnecessary when using GetVertices().
Testing in 18c:
A query with the Table() function produces the same result as a query without it.
With Table():

with cte as (
select sdo_geometry('linestring (10 20, 30 40)')                       shape from dual union all
select sdo_geometry('linestring (50 60, 70 80, 90 100)')               shape from dual union all
select sdo_geometry('linestring (110 120, 130 140, 150 160, 170 180)') shape from dual)
  
select 
    v.*
from 
    cte, table(sdo_util.getvertices(shape)) v

image.pngWithout Table():

with cte as (
select sdo_geometry('linestring (10 20, 30 40)')                       shape from dual union all
select sdo_geometry('linestring (50 60, 70 80, 90 100)')               shape from dual union all
select sdo_geometry('linestring (110 120, 130 140, 150 160, 170 180)') shape from dual)
  
select 
    v.*
from 
    cte, sdo_util.getvertices(shape) v

image.png——————————
Could the 36.31 SDO_UTIL.GETVERTICES docs be updated?
I also asked that the generic Oracle Database docs be improved:
https://community.oracle.com/tech/developers/discussion/4499640/clarify-the-docs-table-keyword-for-table-collection-expressions-is-now-optional/p1?new=1

Comments
Post Details
Added on Jun 12 2022
0 comments
89 views