ALL_VIEWS

How to Resolve ORA-01702: a view is not appropriate here

by Ed Chen
June 27, 2023August 25, 2023

ORA-01702 Tried to create an index, but it failed with ORA-01702. SQL> create index emp_salary on happy_employees (salary); create index emp_salary on happy_employees (salary) … Read More »

How Oracle Search View Text in ALL_VIEWS

by Ed Chen
November 28, 2020December 9, 2022
4 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 »

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