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.

Why? What problem are you trying to solve that causes you to want to check the syntax without executing the query? It's possible that you want your client application to prepare the statement without executing it (or to use dbms_sql.prepare) but that would execute DDL statements. — Justin Cave
– Justin Cave, Commented Jun 9, 2015 at 5:12
more information about dbms_sql.prepare. (Possible duplicate) stackoverflow.com/questions/20745010/… — ibre5041
– ibre5041, Commented Jun 9, 2015 at 7:19

sqluser · Accepted Answer · 2015-06-09 05:10:01Z

17

Using EXPLAIN PLAN

EXPLAIN PLAN FOR SELECT FROM emp;

ERROR at line 1: ORA-00936: missing expression

EXPLAIN PLAN FOR SELECT * FROM emp;

Explained

answered Jun 9, 2015 at 5:10

sqluser

5,7027 gold badges44 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

jimifiki Over a year ago

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 Over a year ago

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

mighty_dev Over a year ago

Does this work only for select and not for alter queries?

Collectives™ on Stack Overflow

How can I validate SQL query syntax in oracle database?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related