Tag: oracle
- Datapump metadata-only import changes datalength when importing with conversion
- Zero/NULL Case Trick
- Oracle pl/sql block throwing ORA-00922: missing or invalid option
- Updating a Json column that contains a JsonArray using Json_transform() function in Oracle Database 19c Enterprise Edition
- Connecting to multiple Oracle databases hosted on different machines – Username as common and different password for each database
- Expdp partitioned table, Impdp Into non-partitioned table same structure
- Select SDO_GEOMETRY line vertices as rows
- Extract SDO_GEOMETRY line vertices into a nested table column (in a query resultset)
- Oracle 11gR2 (11.2.0.4.0) – Drop and Remove Datafiles
- Group by x, get other fields too (comparing options and performance)