Tuesday, April 19, 2011

What do you think of the following query?

What do you think of the following query?

select keyword from v$reserved_words;



At first glance, it looks as if it is an invalid query.
But No, it is not an invalid query.
It gives you all the keywords that are being used in Oracle.
But MIND IT !!, you must have the access to this view to run this query, else you'll get a message : Table or View Does not exist.

V$reserved_words is a view.

No comments:

Post a Comment