Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 10 May 2016

Query to Finding Columns and Tables

The all_tab_columns is a useful table that can be queried for such information.
For example:

SELECT  table_name, column_name
FROM   all_tab_columns
WHERE column_name like 'PO_HEADER%’;

           
TABLE_NAME                                              COLUMN_NAME
------------------------------ ------------------       ------------------------
PO_ACCRUAL_RECONCILE_TEMP        PO_HEADER_ID
PO_ACCRUAL_WRITE_OFFS                   PO_HEADER_ID
INVFV_MOVEMENT_STATISTICS            PO_HEADER_NUMBER
MTL_MOVEMENT_STATISTICS_V                 PO_HEADER_ID
FINANCIALS_PURGES_V                                 PO_HEADERS

You can also find all tables from,

select * from all_objects
where object_name like '%PO_HEADERS_ALL%'
and object_type = 'TABLE'
Share this article :

2 comments:

  1. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

    ReplyDelete
  2. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete