Create Table SQL Statementby Ed ChenMay 10, 2023May 24, 2023What is the syntax of CREATE TABLE in Oracle? Since the syntax of CREATE TABLE statement can be very flexible and complicated, so using text-based… Read More »Create Table SQL Statement
How to Resolve ORA-28232: invalid input length for obfuscation toolkitby Ed ChenJuly 17, 2021June 4, 2022ORA-28232 Developers tried to obfuscate data by DBMS_OBFUSCATION_TOOLKIT in a database with multi-byte character set and got this error. ORA-28232: invalid input length for obfuscation… Read More »How to Resolve ORA-28232: invalid input length for obfuscation toolkit
How to Set NLS_LENGTH_SEMANTICS Temporarilyby Ed ChenMay 19, 2021December 17, 2021NLS_LENGTH_SEMANTICS Let's see what NLS_LENGTH_SEMANTICS of the database currently set. SQL> conn hr/hr@orclpdb Connected. SQL> show parameter semantics; NAME … Read More »How to Set NLS_LENGTH_SEMANTICS Temporarily
How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONGby Ed ChenNovember 28, 2020October 24, 2021ORA-00932 ORA-00932 means that SQL engine wanted to retrieve CHAR strings, but it saw LONG data type, which is unsearchable. So SQL engine refused to… Read More »How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONG