On Monday, September 11, 2006, at 10:48AM, Seth Dillingham <[EMAIL PROTECTED]> wrote:
>On 9/11/2006, Daniel Farmer said: > >> 1. SQL (PL/SQL) and SQL (Generic) seem switched - SQL (Generic) colors >> many keywords that are PL/SQL keywords (BEGIN END EXCEPTION WHEN RETURN) >> while SQL (PL/SQL) seems to color a sub-set of basic keywords (SELECT INTO >> FROM WHERE FUNCTION) > >Dan, > >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. Seth, Looking around I find the same thing you are seeing. I found a copy of the SQL92 spec linked from wikipedia ( http://en.wikipedia.org/wiki/SQL-92 ) at ( http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt ) but details on either the 1999 or 2003 are limited and it seems you have to buy the standard to get them. There was a link to a late draft of 2003 spec at ( http://www.wiscorp.com/sql_2003_standard.zip ) 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. dan -- ------------------------------------------------------------------ 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]>
