CREATE VIEW

How to Resolve ORA-01730: invalid number of column names specified

by Ed Chen
January 2, 2021December 9, 2022

ORA-01730 ORA-01730 means that the number of listed columns between the target (the view) and the source (the base table) in the CREATE VIEW statement… Read More »

How to Resolve ORA-01031: Insufficient Privileges

by Ed Chen
June 24, 2020February 22, 2023
1 Comment

ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »

How to Resolve ORA-00942: table or view does not exist

by Ed Chen
March 23, 2019February 20, 2023
4 Comments

ORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »