Why reusable marked as keyword

[ori marko]

I notice that reusable is reserved keyword according to PL/SQL Developer.

I can't find any documentation of reusable keyword in oracle, and not exists in Oracle/PL/SQL's Reserved Words
I can use this "keyword" to create table, e.g:

create table reusable(reusable varchar2(1))

So why reusable is marked as a keyword and by who?

 

[Marco Kalter]

I see that REUSABLE is defined as a SQL language keyword in default.kwf in the PL/SQL Developer installation directory. I cannot immediately find any reference to this keyword in the Oracle Documentation. We'll investigate. You can remove it from the default.kwf file.

 

[Peter H.]

It's because the "keyword" is "(pragma) serially reusable" for packages. The problem here, though, is that plsqldev is not (yet) capable of accepting space-delimited multi-word "keywords". The same problem will arise with Oracle 12c's analytic views, where "view" is a keyword, but "analytic" is not, yet "analytic view", again, is.

I have tried adding some of these "multi-keywords" into either custom.kwf or default.kwf... but no luck with making them highlighted.

Marco, it would be good to enhance plsqldev with these "multi-keywords".

 

[ori marko]

Hi

Shouldn't it be one word "SERIALLY_REUSABLE" and not with space
"SERIALLY REUSABLE"https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/seriallyreusable_pragma.htm#LNPLS01346

 

[Peter H.]

Hi

I'm an idiot. You are right. Thank you for correcting me. Anyway, the problem with "multi-keywords" still holds true.