SQL Developer "usage" keyword

1.1k views Asked by At

enter image description here

I have a field in a table called "usage". (I did not create it) In a query in SQLDeveloper the word "usage" is highlighted as if it is a keyword (like "Select")

Is "usage" a keyword is SQL? (or Oracle) If yes, what does it do? If no, why is it highlighted?

You can understand how difficult it has been to search for any information on this. Putting the word usage on any search returns results about to use stuff :-(

Thanks Paul Mc

3

There are 3 answers

0
Marcin Wroblewski On BEST ANSWER

One example I know is

ALTER INDEX indexname MONITORING USAGE

See documentation

2
thatjeffsmith On

It's an identifier, not a keyword. SQL Developer allows you to highlight them independently.

enter image description here

0
Frank Schmitt On

According to the

Oracle documentation and the PostgreSQL documentation

it's indeed a keyword, and an ANSI keyword to boot. As to its usage (pun intended), I've got no idea.

UPDATE

According to this SQL grammar by Jonathan Leffler (I guess this is the same Jonathan Leffler, but I'm not 100% sure), it's a GRANTable privilege.

At least in MySQL, this privilege seems to be used to indicate the absence of privileges.