ORA-00984: column not allowed here Oracle PL/SQL error message: ORA-00984: column not allowed here. Cause: A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement. Solution: Check the syntax of the statement and use column names only where appropriate. Example: CREATE TABLE…(Continue Reading)
Author: Dev
ORA-01416: two tables cannot be outer-joined to each other
ORA-01416: two tables cannot be outer-joined to each other Oracle PL/SQL error message: ORA-01416: two tables cannot be outer-joined to each other. Cause: Two tables in a join operation specified an outer join with respect to each other. If an outer join is specified on one of the tables in a join condition, it may…(Continue Reading)
ORA-01468: a predicate may reference only one outer-joined table
ORA-01468: a predicate may reference only one outer-joined table Oracle PL/SQL error message: ORA-01468: a predicate may reference only one outer-joined table. Cause: A predicate in the WHERE clause has two columns from different tables with “(+)”. Solution: Change the WHERE clause so that each predicate has a maximum of one outer-join table. Students table…(Continue Reading)
ORA-01427: single-row subquery returns more than one row
ORA-01427: single-row subquery returns more than one row Oracle PL/SQL error message: ORA-01427: single-row subquery returns more than one row. Cause: The outer query must use one of the keywords ANY, ALL, IN, or NOT IN to specify values to compare because the subquery returned more than one row. Solution: Use ANY, ALL, IN, or…(Continue Reading)
ORA-00905: missing keyword
ORA-00905: missing keyword Oracle PL/SQL error message: ORA-00905: missing keyword. Cause: A required keyword is missing. Solution: Correct the syntax. Example: CREATE OR REPLACE VIEW VIEW_1 SELECT * FROM TEST3; Output: ORA-00905: missing keyword Correct: CREATE OR REPLACE VIEW VIEW_1 AS SELECT * FROM TEST3; Output: view VIEW_1 created.