Monday, January 26, 2009

Missing Keyword

INPUT:
SQL> create view emp_view
2 select * from employee_tbl
3 /

OUTPUT:

select * from employee_tbl
*
ERROR at line 2:
ORA-00905: missing keyword
SQL>

ANALYSIS:
Here the syntax is incorrect. This error occurs when you omit a mandatory word with any given command syntax. If you are using an optional part of the command, that option may require a certain keyword. The missing keyword in this example is as. The
statement should look like this:
SQL> create view emp_view as
2 select * from employee_tbl
3 /

No comments: