Tag: oracle
- Why doesn’t /*+ NO_INDEX*/ hint , affect the “execution plan”
- SPFILE invalid after being edited in Windows
- Oracle – why do I need INITRANS if I have MAXTRANS
- Oracle Lag() on date output wrong data
- Getting “ORA-04030: out of process memory” on medium insert with large pga and sga
- Oracle database won’t start, ORA-03113
- 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