Pavel Roskin wrote:
The question about comments may be for me. I remember that I just scannedthe web for SQL files and checked sources of PostgreSQL and MySQL. PostgreSQL uses "--". MySQL uses "#". Take MySQL source and look for*.test files.It's very bad - # has not special sence and can be used in keywords in Oracle. Only --, rem[ark] and /* */ are legal comments there.You mean names of columns and tables? MySQL doesn't allow it.
Yes, and I think Oracle SQL is more compatible with ANSI.
How about this? ================================= --- sql.syntax +++ sql.syntax @@ -477,7 +477,7 @@ keyword , brightcyan/14 keyword ; brightcyan/14-context # \n brown/22+context linestart # \n brown/22 spellcheckcontext exclusive -- \n brown/22=================================
This works just fine for Oracle SQL. Thanks! -- Regards, Andrew . Samoilov