Function-based Index

How to Resolve ORA-28348: index defined on the specified column cannot be encrypted

by Ed Chen
September 16, 2022September 2, 2022

ORA-28348 Tried to encrypt a column, but it failed with ORA-28348: SQL> alter table oe.customers modify (cust_first_name encrypt no salt); alter table oe.customers modify (cust_first_name… Read More »

Create Case-Insensitive Unique Index in Oracle

by Ed Chen
April 29, 2022May 27, 2023

Case Insensitive Index Using unique case-insensitive constraint in a column sometimes is reasonable in business logic to prevent duplicate items. Let's see a table that… Read More »

How to Resolve ORA-01861: literal does not match format string

by Ed Chen
May 17, 2019September 14, 2023
3 Comments

ORA-01861 ORA-01861 means that the date format between two operands cannot be comparable. Usually, it happens when comparing DATE with CHAR. Therefore, we should make… Read More »

JavaScript is not enabled. Please enable it and reload the page.