How to check syntax of SQL query in Oracle database?

Question

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

This check works in SQL Server. But he does not work in oracle.

Is there any syntax for checking a query that is valid or not in Oracle.

Answer 1

Using EXPLAIN PLAN

 EXPLAIN PLAN FOR SELECT FROM emp; 

ERROR on line 1: ORA-00936: expression missing

 EXPLAIN PLAN FOR SELECT * FROM emp; 

Explanation