Re: When DO You Use a Semicolon?

Tim, the semicolon is not part of the SQL standard. There is no SQL statement terminator defined in the standards.

Thus, when you talk to Oracle, no semicolon.

However, many client tools (like SQL*Plus) needs to have a statement terminator so that you can tell it when you have done typing and the statement can be transmitted.

This terminator can also be changed in SQL*Plus using the SET command.

In MS-Access, you construct a SQL statement that will be passed directly to Oracle (hopefully without too much intereference from ODBC/ADO/whatever). No semicolon required as you are talking "clean SQL". Ditto for all other programming languages.

--
Billy