To make life easier it is often best to add a comment unique to your statement, for instance SELECT /* my_custom_comment */ select_list FROM tab_name. You can find out the SQL ID and hash value of your SQL statement by querying v$sql. The hash value is based on the first few hundred characters of your statement, so hash collisions can occur, especially for long statements. Once your SQL statement has passed both checks with flying colours, your statement receives a SQL ID and (MD5) hash value. These checks expand views referenced by your statement into separate query blocks.įor more details we refer you to the chapter Syntactic and Semantic Checking of the Programmer’s Guide to the Oracle Precompilers for your database version. Oracle also inspects whether you are authorized to access the data. Now Oracle moves on to evaluate the meaning of your syntactically legal code, which is known as semantic analysis.Īll references to database objects and host variables are scrutinized by Oracle to make sure they are valid. If you have neither made any typos in keywords and the like nor sequenced the language elements improperly, you’re good for the next round.
The syntax check verifies whether the language elements are sequenced correctly to form valid statements. To check these products out and to download them, head on over to their downloads page.What happens to your SQL statement when you hit execute?įirst, Oracle checks you statement for any glaring errors.
#APEX SQL PLAN LICENSE#
ApexSQL Doc – SQL Server documentation tool (Coming soon)Īnd if that isn’t enough for you, they also provide a FREE Single Server instance license of ApexSQL Monitor.ApexSQL Data Diff – SQL Server data compare tool.ApexSQL Diff – SQL Server schema compare tool.They also provide free community editions for the following tools that support Windows SQL Azure Databases and SQL Server Express:
#APEX SQL PLAN INSTALL#
No requirement to install additional, non-free softwareīut wait, there is more (I sound like an infomercial).No professional version or non-free features you must pay for.
#APEX SQL PLAN UPGRADE#
No additional costs to upgrade to newer versions of SQL Server e.g.No annoying embedded ads or nag screens.No crippleware, time bombs, or bait and switch.Well, according to their site, free means the following: If you are a developer using SSMS, you definitely must download their free tools and give them a try. I would be amiss if I didn’t share this with the developer community out there. Azure Databases – Restore Local Database To Azure.Execute Script Error Resolved In SQL Server Management Studio.Automate Standard Comment Blocks For New SQL Queries.Easily Generate Table Change Scripts In SQL Server Management Studio.Script Table Data In SQL Server Management Studio.Looking for something else? Try these links instead: I was amazed by the feature richness of these tools. Now that is out of the way, check out ApexSQL tools. Before I carry on, I was in no way compensated for this blog post at all. ApexSQL has a few free tools on their site.