Parsing queries in Oracle SQL Developer

Is there a way to parse code in SQL Developer (oracle) without actually touching tables/packages data like you can do with "parse" option in SQL Management studio?

Answers


There is no option to merely parse the SQL statement to validate the syntax.

You could choose the "Explain Plan" option (F10 in the Windows version of SQL Developer), that will validate the syntax as part of generating the query plan. If there is a syntax error, you'll get the error message when you attempt to generate the plan but you generally won't get the line and column of the error which makes debugging more challenging.


I was looking for this right now and couldn't find an option in Oracle SQL Developer.

I know a service called SQL Fiddle that can help in such situations where one needs to test/parse/validate an adhoc PL/SQL script. Using SQL Fiddle you can do this:

Select Oracle 11g R2 (as available right now) in the dropdown and type your script in the left text area. Press Build Schema button. If your script is valid then it'll show you Schema Ready message like this:


Need Your Help

stdlib not working in nxtOSEK

c++ nxt lego

I am programming the Lego Nxt Brick with nxtOSEK in C++. It seems that the stdlib.h library is not working, but the string.h library works fine. Has anyone seen this before?