oracle18c Examples and Free Source Code

Function-based index on function returning number from abstract datatype...

sql oracle-database indexing abstract-data-type oracle18c

Convert SDO_ORDINATE_ARRAY to string using a function (for a function-based index)...

sql oracle-database function oracle18c varray

Convert SDO_ORDINATE_ARRAY to built-in VARRAY (to create function-based index)...

sql oracle-database indexing oracle18c varray

Use negative number to extract element at end of varray list (in a custom member function)...

sql oracle-database plsql oracle18c varray

Use Query Result Cache in query with varray...

sql oracle-database query-optimization oracle18c varray

Why does deterministic function return unexpected numbers in CONNECT BY LEVEL query?...

sql oracle-database deterministic oracle18c connect-by

Extract varray element by index number using custom type's member function...

sql oracle-database member-functions oracle18c oracle-spatial

Get varray values as concatenated text list...

sql oracle-database concatenation oracle18c varray

Find problem XML values by catching XMLTABLE() errors in custom function...

sql xml oracle-database oracle18c xmltable

Determine what rows are causing error in query...

sql oracle-database oracle18c oracle-spatial

Extract specific value from XML array (where FieldName = x)...

sql arrays xml oracle-database oracle18c

Extract vertices from SDO_GEOMETRY lines and store as points in SDO_GEOMETRY_ARRAY...

sql oracle-database oracle18c oracle-spatial varray

Generate grid line coordinates using SQL...

sql oracle-database geometry oracle18c

Why does SHAPE.SDO_ORDINATES(1) work in PL/SQL, but not in SQL?...

sql oracle-database attributes oracle18c oracle-spatial

Create an ODCI list of SDO_GEOMETRY objects...

oracle-database oracle18c oracle-spatial

Convert MDSYS.ST_LINESTRING subtype value to MDSYS.ST_GEOMETRY supertype...

sql oracle-database type-conversion oracle18c oracle-spatial

Collapse vertex rows into nested table type (aggregated by ID)...

sql oracle-database oracle18c oracle-spatial

Why do we need to Treat() MDSYS.ST_GEOMETRY as ST_LINESTRING to use ST_PointN(1)?...

sql oracle-database oracle18c oracle-spatial

Why does (SHAPE).SDO_ORDINATES(1) syntax fail, but (SHAPE).ST_PointN(1) succeeds?...

sql oracle-database oracle18c oracle-spatial

Cross-joining with a table object propagates rows (without needing Table() function)...

sql oracle-database oracle18c oracle-spatial object-type

Utilize function-based spatial index in SELECT list...

oracle-database indexing oracle18c spatial-index oracle-spatial

Utilize a function-based index to precompute columns, while also selecting non-indexed columns...

sql oracle-database indexing oracle18c oracle-spatial

Cross join to varray without using Table() expression...

sql oracle-database join oracle18c

What does OBJECT_TYPE(…) do in a SELECT query?...

sql oracle-database constructor oracle18c object-type

Replace value in SDO_ELEM_INFO_ARRAY varray...

oracle-database oracle18c oracle-spatial varray

Utilize a function-based index while selecting additional columns...

sql oracle-database indexing query-optimization oracle18c

Why aren't rows returned in the order of insertion?...

oracle-database select insert oracle18c

Include multiple inline functions and multiple CTEs in a WITH clause in a single query...

sql oracle-database with-statement oracle18c inline-functions

Look up SDO_GEOMETRY validation error code using SQL...

sql oracle-database error-code oracle18c oracle-spatial

OOTB Oracle IFERROR function to handle rows that cause errors in a query...

sql oracle-database function error-handling oracle18c