Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

data dictionary

Want to search packages, views, table, functions, etc for an object name 'company_search' . What is the query from data dictionary?

1 Solution
select * from all_objects where object_name = 'COMPANY_SEARCH';
Muhammad Ahmad ImranDatabase DeveloperCommented:
select * from all_objects where OBJECT_NAME = 'company_search'
slightwv (䄆 Netminder) Commented:
Are you asking if the object is used in source code?

There is a DBA_DEPENDENCIES view:
select owner, name, type from dba_dependencies where referenced_name='COMPANY_SEARCH';

That will work if the procedure code doesn't use dynamic SQL.  IF if might then:
select name from user_source where upper(text) like '%COMPANY_SEARCH%';
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

johnsoneSenior Oracle DBACommented:
ALL_OBJECTS would only give you the list of objects you have access to.  DBA_OBJECTS is a better choice to search, it will give you all objects.
Naveen KumarProduction Manager / Application Support ManagerCommented:
i will second johnsone comment that while searching, you should query DBA_OBJECTS view.

So can you try the below 2 queries and you should get some output if such object exists from one of the queries.

select * from DBA_OBJECTS where object_name = 'COMPANY_SEARCH';  

--> this will help to get you the object if it is created with just company_search as the object name without quotes enclosing the name.


select * from DBA_OBJECTS where object_name = 'company_search';  --> this will help to get you the object if it is created with "company_search" as the object name with quotes enclosing the obect name to preserve its exact name in lower case letters.
This data is recorded in the systemtables and a full list can be found at:
The techonthenet link above is  is not a full list of the dictionary tables.
In fact those aren't tables at all, but views.

It is however, as stated in the link, a set of commonly used views.
However the critical views have already been mentioned above.
if you're looking for a procedure called "company_search"  you can look in dba_procedures/all_procedures to see where it is defined whether it is a stand alone procedure or defined within a package.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now