How can I define a type for Oracle PL/SQL so I can get correct syntax highligting? The existing SQL types do not recognize a number of oracle datatypes, such as VARCHAR2.
Oracle PL/SQL file type
Probably you will want to add missing types here:
You can follow the instructions in the readme to make the changes locally and then submit a Pull Request
I’m not sure that is the best approach – I wouldn’t want to pollute the PostgreSQL syntax with oracle specific types which would make the syntax invalid for both PostgreSQL and Oracle. I’ll probably have to define a separate syntax for Oracle just to keep things organized. Seems like a large undertaking, though.
You can extend the PostgreSQL syntax and just override the types if that is the main difference
Well, if I wanted it solely for my personal use, I guess that would work – but your initial suggestion was to submit a pull request, which would end up invalidating the syntax for everyone else.
I might be wrong, but I think @kingkeith meant to extend from the PG Syntax (so inherit, not overwrite).
I think that would be rather confusing on Oracle, since PostgreSQL has a lot of types Oracle doesn’t. I think I’ll need to extend the generic SQL syntax and work up from there.
oh sorry, I somehow misread PL/SQL as PG/SQL and thought it was some proprietary extension of Postgres. Yeah, I guess work from the generic one. Can still submit a PR with a new sublime-syntax for Oracle