Create Table SQL Statement
What 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
CHAR
How to Resolve ORA-28232: invalid input length for obfuscation toolkit
ORA-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 Temporarily
NLS_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 LONG
ORA-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