Question

How I can Find Undelying Tables & Views in Oracle 11i (HRMS)

E-business

Hi,,,

i want to ask about the way that help me in finding the underlying Tables & Viwes because i used Record History Feature but it didn't work (Record History is not available).

Thanks in advance for your corporation..

In each version of Oracle, there's a management tool. I won't mention the name of it here, because the name keeps changing. However, it should be on your menues or in your applications list. You can navigate from database to schema, and within the schema see your tables, views, and program objects. Within tables, you can see columns, triggers, constraints, indeces, and the like. Within program objects, you can see procedures, functions, and packages.

To determine which tables are used in views, you can go to views and display the view definition. To determine which tables and views are used in program objects, you can go to the particular program object, and display its definition.
---
Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linker.com)
800-315-1174 (+1-949-552-1904)