Saket Saket -4 years ago 123
SQL Question

In Oracle what is the difference between ALL_OBJECTS and all_objects (lower case)?

select * from all_objects where object_type = 'PROCEDURES' and object_name = 'FTR_PROC'


The SQL query shown above returned me nothing.
But the below one returned me 1 row.

SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE' AND OBJECT_NAME = 'FTR_PROC'


Why?

Answer Source

In Oracle, table names and field names are case-insensitive, unless you put quotes around them (as in "all_objects"). Therefore there should be no difference between all_objects and ALL_OBJECTS.

The reason you are getting different results with the above two queries is probably because in the first one you refer to 'PROCEDURES' instead of 'PROCEDURE'

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download