Geek Answers Handbook

Parsing Queries in Oracle SQL Developer

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

+4
source share
2 answers

There is no way to simply parse the SQL statement to check the syntax.

You can select the Explain Plan option ( F10 in SQL Developer for Windows), which will check the syntax as part of generating the query plan. If there is a syntax error, you will receive an error message when you try to generate a plan, but you usually will not get a row and an error column, which makes debugging more difficult.

+3
source

I was looking for this right now and could not find an option in Oracle SQL Developer.

I know a service called SQL Fiddle , which can help in such situations when you need to test / analyze / test adhoc PL / SQL script. Using SQL Fiddle, you can do this:

Select Oracle 11g R2 (as available right now) in the drop-down list and enter the script in the left text area. Click the Build Schema button. If your script is valid, it will show you a Schema Ready message as follows:

enter image description here

+2
source

More articles:


All Articles