Logo Background

FND_TABLES Table Name, FND_COLUMNS Column Name

  • By on April 9, 2009 | 1 Comment

    If you are looking for specific column name which comes along with the table name, use the query below in Oracle: –

    SELECT t.table_name , c.column_name, c.table_id FROM fnd_columns c, fnd_tables t
    WHERE c.column_name = 'STOP_ID'
    AND c.table_id = t.table_id

    To search for the table name, you can use the query as below: –

    SELECT object_name,object_type
    FROM dba_objects
    WHERE LOWER(object_name) LIKE '%countr%'
    AND object_type IN ('TABLE','VIEW')
    Previous
    Next
    » Oracle Blocking Session Checking Script
  1. #1 khizar
    November 15, 2011 3:26 am

    Thanks it was really help full and i need some more information about custom forms

    Post ReplyPost Reply
Leave a Comment