Every Oracle SELECT statement must contain a FROM clause. Specify the Table Name followed by the FROM keyword. If FROM clause is missed in a SELECT statement, Oracle raises error.

Which are the statements that demand FROM clause?

FROM clause in a query specifies which is the table to get the data from. Also other clauses of the query can access columns for use in expressions. Following are the SQL statements that require FROM clause keyword.

• SELECT
• DELETE
• MERGE

But all SQL statement need a table for their operation. For example, with INSERT you use INTO clause to specify the table name. Similarly, UPDATE statement is followed by table name.