Search code examples
Oracle - Filter JSON array while using json_objectagg...


sqljsonoracle-databaseplsqloracle19c

Read More
Parsing JSON into oracle sql...


sqljsonoracle-databaseoracle-sqldeveloperoracle19c

Read More
Two login pages after opening Database Actions in Autonomous...


oracle-databaseoracle19coracle-autonomous-db

Read More
Update CLOB JSON column with case gives ORA-00932: inconsistent datatypes: expected CHAR got CLOB...


sqljsonoracle-databasecloboracle19c

Read More
Oracle scheduler get all possible interval runs...


oracle-databaseoracle-apexoracle19c

Read More
Oracle - json_mergepatch updating column to NULL...


sqljsonoracle-databasesql-updateoracle19c

Read More
PL/SQL/Oracle DB: Procedure: ORA-29013: SSL MAC verification failure (Database 19c)...


oracle-databaseplsqloracle12coracle19c

Read More
Oracle Update - JSON Merge Patch with more than 4000 characters...


jsonmergeoracle19c

Read More
Group BY query utilizes indexes, but window function query doesn't...


oracle-databasequery-optimizationmaximooracle19c

Read More
LNNVL to replace NOT IN?...


oracle-databaseoracle19c

Read More
Is it suggestible to have 2 separate tables for Read and DML...


sqloracle-databaseoracle19c

Read More
Use inline function in subquery (in a WHERE clause)...


oracle-databasesubquerywith-statementoracle19cinline-functions

Read More
Oracle Spatial question: can SDO_ORDINATE_ARRAY be populated using query results from another Oracle...


oracle-databaseoracle19coracle-spatial

Read More
Oracle JSON_QUERY with path as query column value...


oracle-databaseoracle19c

Read More
how to retrive data from VARRAY and filter it...


sqloracle-databaseoracle19c

Read More
How to restore an earlier version of a table from recyclebin?...


oracle19crecycle-binflashback

Read More
External table read issue on 19c...


oracle-databaseoracle19cexternal-tables

Read More
Oracle Cloud DB 19c bug with JSON_ARRAYAGG...


oracle-databaseoracle19cjson-arrayagg

Read More
Oracle doesn't inherit number scale and precision for columns in a view consumed by Kafka Connec...


oracle-databaseapache-kafkaapache-kafka-connectoracle19c

Read More
Does Oracle allocate different PGA's for the same user when connected from multiple PCs?...


oracle-databasedatabase-performancedatabase-administrationsqlperformanceoracle19c

Read More
SQL: Oracle 19c unique ID...


sqloracle19c

Read More
Rank on multiple columns in Oracle 19C...


oracle-databaserankoracle19cranking-functionsoracle-analytics

Read More
How to get the quarter corresponding to a date in Oracle SQL 19c...


sqloracle-databaseoracle19c

Read More
How to remove collection type name from results...


sqloracle-databaseplsqloracle19c

Read More
Updating a Json column that contains a JsonArray using Json_transform() function in Oracle Database ...


jsonoracle-databasespring-bootoracle19c

Read More
Increment for loop by a fraction/ range of values in Oracle 19c...


oracle-databasefor-looporacle19cnested-for-loop

Read More
How to extract lines created or modified since the last hour...


sqloracle19c

Read More
SQL for nested WITH CLAUSE - RESULTS OFFSET in Oracle 19c...


oracle19cwith-clause

Read More
Oracle EM Express not showing all options...


oracle-databaseoracle19coracle-enterprise-manager

Read More
Convert two datetimes to timestamps and keep the larger one...


oracle19c

Read More
BackNext