oracle18c-CodePudding

Tags > oracle18c

09-09OSoracle SQL counter restarts when time difference is > x
09-08BlockchainHow to group by date and not datetime in Oracle?
08-18OSSelect rows where related rows only have unmatched years
07-19NetGenerate rows to fill in gaps between years, carry over a value from previous year
07-18Back-endHow to select maximum records from timestamp and do the operation using LISTAGG
07-15NetJoin to XML query is only performant with redundant hardcoded WHERE clause
07-14Back-endFunction-based index on function returning number from abstract datatype
07-11databaseConvert SDO_ORDINATE_ARRAY to string using a function (for a function-based index)
07-09MobileConvert SDO_ORDINATE_ARRAY to built-in VARRAY (to create function-based index)
07-06Software designWhy does CROSS JOIN LATERAL break up array's SDO_GEOMETRY object into individual attributes?
07-05OSExtract varray element by index number using custom type's member function
07-04MobileSuccinct way to select where COST1 is different than COST2 (treat null=null)
06-30front endSuccinct way to join between XML queries?
06-27databaseExtract specific value from XML array (where FieldName = x)
06-21NetConvert MDSYS.ST_LINESTRING subtype value to MDSYS.ST_GEOMETRY supertype
06-21NetGet point geometries as rows for each vertex in SDO_GEOMETRY line
06-21otherGet varray values as concatenated text list
06-20BlockchainWhy does (SHAPE).SDO_ORDINATES(1) syntax fail, but (SHAPE).ST_PointN(1) succeeds?
06-20Software designWhy do we need to Treat() MDSYS.ST_GEOMETRY as ST_LINESTRING to use ST_PointN(1)?
06-16EnterpriseWhat does OBJECT_TYPE(…) do in a SELECT query?
06-15databaseGenerate grid line coordinates using SQL
06-15otherCross-joining with a table object propagates rows (without needing Table() function)
06-15otherCollapse vertex rows into nested table type (aggregated by ID)
06-14front endCross join to varray without using Table() expression
06-12OSCreate an ODCI list of SDO_GEOMETRY objects
06-12Back-endWhy does SHAPE.SDO_ORDINATES(1) work in PL/SQL, but not in SQL?
06-12EnterpriseWorking with SDO_GEOMETRY ordinates as a table in a column subquery
06-12EnterpriseGet value from ODCIVARCHAR2LIST at a specific index position (in a SQL query)
06-10BlockchainInclude multiple inline functions and multiple CTEs in a WITH clause in a single query
06-10databaseWhy does SHAPE.SDO_ORDINATES(1) work in PL/SQL, but not in an SQL query?
06-09NetOOTB Oracle IFERROR function to handle rows that cause errors in a query
06-09OSReplace value in SDO_ELEM_INFO_ARRAY varray
06-09OSLook up SDO_GEOMETRY validation error code using SQL
06-04databaseUtilize function-based spatial index in SELECT clause
06-01Back-endDetermine what rows are causing error in query
05-20front endIs In-Memory a extra-cost option? (Oracle)
05-18otherUtilize a function-based index while selecting additional columns
05-17otherTreat Oracle subtype as supertype
05-17OSExplain plan hint details as plain text
05-04Software designConvert VARRAY to text (for concatenation)

46 1 2 Next Last