oracle18c

35 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Generate rows to fill in gaps between years, carry over a value from previous year
user_55767710
•
1
3
64
oracle18c time-series oracle sql
Why does deterministic function return unexpected numbers in CONNECT BY LEVEL query?
user_55767710
•
3
1
98
connect-by oracle18c deterministic oracle sql
Why do we need to Treat() MDSYS.ST_GEOMETRY as ST_LINESTRING to use ST_PointN(1)?
user_55767710
•
1
1
74
oracle-spatial oracle18c oracle sql
Generate grid line coordinates using SQL
user_55767710
•
1
2
123
oracle18c oracle geometry sql
Collapse vertex rows into nested table type (aggregated by ID)
user_55767710
•
2
1
70
oracle-spatial oracle18c oracle sql
Cross-joining with a table object propagates rows (without needing Table() function)
user_55767710
•
2
1
76
oracle-spatial object-type oracle18c oracle sql
Why does SHAPE.SDO_ORDINATES(1) work in PL/SQL, but not in SQL?
user_55767710
•
3
3
143
oracle-spatial oracle18c oracle attributes sql
Utilize function-based spatial index in SELECT list
user_55767710
•
1
4
114
oracle-spatial spatial-index oracle18c indexing oracle
Count based on the max status on a given date, with grouped data
Admin1
•
2
2
139
oracle18c group-by oracle sql
How can I compare a Unix epoch timestamp with a DATE in SQL?
user_23403410
•
1
1
695
sql-date-functions oracle18c epoch unix sql
Hot Questions