On Sep 11, 2006, at 3:42 PM, Daniel Farmer wrote:
On Monday, September 11, 2006, at 10:48AM, Seth Dillingham
<[EMAIL PROTECTED]> wrote:
Do you have or know of a list of the 'official' built-in
keywords for
generic SQL?
I've looked into this before, and I can't seem to find such a
list without
buying a copy of the language spec.
I just started mine with what I was using at the time, and kept
adding to it over time (including things that aren't necessarily
keywords) until it had most of the stuff I commonly used. I know my
list is missing many keywords as well which is why I had high hopes
for the 8.5 support languages.
I do have an Oracle 9i Complete Reference book that was where I
started. I didn't copy every keyword from it, just the ones I
thought I'd be using at the time. Maybe it's time to go back
through and compile a more complete list.
I copied every one, back when I did mine (when BBEdit 8
was released):
http://www.annoying.org/bbedit/SQLLanguageModule.plist
http://www.annoying.org/bbedit/PLSQLLanguageModule.plist
http://www.annoying.org/bbedit/PLSQL9LanguageModule.plist
I'm using the 'reserved SQL terms' in the Oracle manual
as the basis for the SQL module.
And I'm noticing the same reversal between the generic &
PL/SQL specific language modules -- but it's not that clean
cut. More of my keywords (by total on the screen) are colored,
but there's a few obscure Oracle terms that are colored in
the PL/SQL module, and not the generic one (eg, heap, type,
between, flush, explain, if, index, lock, long, rename, etc.
And a few of those I know are ANSI-SQL)
----
Joe Hourcle
--
------------------------------------------------------------------
Have a feature request? Not sure the software's working correctly?
If so, please send mail to <[EMAIL PROTECTED]>, not to the list.
List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml>
List archives: <http://www.listsearch.com/BBEditTalk.lasso>
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
