ALL_VIEWS

How Oracle Search View Text in ALL_VIEWS

by Ed Chen
November 28, 2020December 9, 2022
2 Comments

ALL_VIEWS Dictionary view ALL_SOURCE contains only several object types like PROCEDURE, PACKAGE BODY, FUNCTION, TYPE except VIEW. If you want to search some text for… Read More »

How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONG

by Ed Chen
November 28, 2020October 24, 2021

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 »