Unfortunately, SQL Standards came much later.
Semi-colon is mentioned as the statement terminator in the SQL Standards books also. Sort of like the period at the end of an English statement. Then you need a marker to show the end of each SQL, right? That, my friend, is the semi-colon – the statement terminator. Especially, if it’s running SQLs from a file. You couldn’t really click a button or press a key to execute SQLs. It’s text based and often used in both interactive and batch modes. If there are multiple SQLs, you just highlight one and click and go. In a GUI tool, you can type up a SQL and click on a button (or press a key), the tool will get the SQL executed (send it to Oracle server, get the results, etc.). Several DBAs prefer this tool to flashy new GUI tools, so whichever tool you use, you may want to make sure your SQL will run SQL*Plus. Irrespective of that, SQL*Plus is still going strong. The modern tools are typically GUI based and provide plenty of options for interactive usage. Some prominent ones for Oracle are Toad, SQLTools, PLSQL Developer, etc. Apart from these tools, there are plenty of tools available from outside vendors. Oracle also came up with “better” tools eventually, like iSQL*Plus, SQL Developer, etc. People use it for both interactive and batch use. This is a simple command line tool, yet powerful. Oracle has always come with SQL*Plus as a client tool. To work with it, the vendors – like Oracle, Sybase, etc. provide a client tool. A database system is typically run on a remote server. Then Vendor Said: Let There Be A Database and A (client) Tool So, I thought of explaining these one more time. They really don’t have anything in common, but I guess Oracle behavior in different scenarios could lead one to that. One thing that caught my attention (in bold) was the confusion user(s) had with commit and Forward slash. Oracle pl/sql semi-colon or forward slashĪnd so many variations of these. This is what some enters in say, Google and clicks Search. WordPress has a nice feature in the Stats page that shows the Search engine terms that drove the user to my page. Believe it or not, I still get a lot of traffic to this blog site solely based on this one little topic!! So, I thought I would spend a little more time on this. I even went back and updated it a few times based on the traffic. I posted about Forward slash in Oracle SQL before.