Oracle - Filter JSON array while using json_objectagg...
Read MoreTwo login pages after opening Database Actions in Autonomous...
Read MoreUpdate CLOB JSON column with case gives ORA-00932: inconsistent datatypes: expected CHAR got CLOB...
Read MoreOracle scheduler get all possible interval runs...
Read MoreOracle - json_mergepatch updating column to NULL...
Read MorePL/SQL/Oracle DB: Procedure: ORA-29013: SSL MAC verification failure (Database 19c)...
Read MoreOracle Update - JSON Merge Patch with more than 4000 characters...
Read MoreGroup BY query utilizes indexes, but window function query doesn't...
Read MoreIs it suggestible to have 2 separate tables for Read and DML...
Read MoreUse inline function in subquery (in a WHERE clause)...
Read MoreOracle Spatial question: can SDO_ORDINATE_ARRAY be populated using query results from another Oracle...
Read MoreOracle JSON_QUERY with path as query column value...
Read Morehow to retrive data from VARRAY and filter it...
Read MoreHow to restore an earlier version of a table from recyclebin?...
Read MoreOracle Cloud DB 19c bug with JSON_ARRAYAGG...
Read MoreOracle doesn't inherit number scale and precision for columns in a view consumed by Kafka Connec...
Read MoreDoes Oracle allocate different PGA's for the same user when connected from multiple PCs?...
Read MoreRank on multiple columns in Oracle 19C...
Read MoreHow to get the quarter corresponding to a date in Oracle SQL 19c...
Read MoreHow to remove collection type name from results...
Read MoreUpdating a Json column that contains a JsonArray using Json_transform() function in Oracle Database ...
Read MoreIncrement for loop by a fraction/ range of values in Oracle 19c...
Read MoreHow to extract lines created or modified since the last hour...
Read MoreSQL for nested WITH CLAUSE - RESULTS OFFSET in Oracle 19c...
Read MoreOracle EM Express not showing all options...
Read MoreConvert two datetimes to timestamps and keep the larger one...
Read More