How to put empty string in JSON_OBJECT_T object?...

Get value from ODCIVARCHAR2LIST at a specific index position (in a SQL query)...

Why is INTO needed in this PL/SQL function if the variable doesn't get used?...

Find row with problem shape (SDE.ST_GEOMETRY spatial type)...

Reset counter when it encounters a zero in the column...

What is the version number of Oracle 18c?...

Getting "Unable to check for available memory." on Oracle DB 18c...

How to resolve error ORA-01861: literal does not match format string during insertion of JSON data i...

ORA-17132 Invalid conversion requested during inserting an entity...

Reference a user-defined type in a db<>fiddle session (when inserting a row)...

How to remove oracle database express edition...

Working with SDO_GEOMETRY ordinates as a table in a column subquery...

In Oracle 18c, why is max() much less efficient than order by with fetch first 1 rows only?...

How to add a months to a timestamp with time zone value while keeping the exact same hour...

Assign GROUP_ID to rows based on start/end tags...

Fill in rows per group for pivoting...

Use ROW_NUMBER() window function without specifying ORDER BY...

Generate rows to fill in gaps between years, carry over value from previous year...

Oracle: Generate rows for missing years within range (sysyear + 9)...

Select duplicates (including near-duplicate numbers)...

Using CREATE SCHEMA AUTHORIZATION...

Oracle XE 18c create database error "[DBT-50000] Unable to check for available memory" thr...

oracle SQL counter restarts when time difference is > x...

How to group by date and not datetime in Oracle?...

Select rows where related rows only have unmatched years...

Hibernate - C3P0 JDBC connection pooling...

How to select maximum records from timestamp and do the operation using LISTAGG...

Join to XML query is only performant with redundant hardcoded WHERE clause...

Succinct way to join between XML queries?...

Why does CROSS JOIN LATERAL break up array's SDO_GEOMETRY object into individual attributes?...