How can I validate SQL query syntax in oracle database?

Question

set NOEXEC ON;
Select * from emp;
Set NOEXEC OFF;

This validation is working in SQL Server. But It's not working in oracle.

Is there any syntax to check the query is valid or not in Oracle.

Solution

Using EXPLAIN PLAN

EXPLAIN PLAN FOR SELECT FROM emp;

ERROR at line 1: ORA-00936: missing expression

EXPLAIN PLAN FOR SELECT * FROM emp;

Explained

Comments

[jimifiki]

In my worksheet PLAN is underlined as a mistake and I get an error when I run the command: SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword".

[sqluser]

So what's the question in here? You are missing some keyword in your query.