Home Forums SQL Server 7,2000 Working with Oracle Query to get related Table name from given Column name in Oracle SQL Developer RE: Query to get related Table name from given Column name in Oracle SQL Developer

  • Yes,

    Thanks for the guidence

    I have used Query something like this to get all the Table columns which are having nearly same name like below

    [Quote]

    select u.owner AS OWNERNAME, u.table_name as Source_TableName,u.column_name as Source_Column_Name

    from all_tab_columns u

    where Upper(u.column_name) like upper('%Colun_Name%')

    [/Quote]

    It worked fine i think.... but now i am facing another problem Please help me to find it

    Can i get a Query to know the Owner name , Table name and Column name from the Entire Database which are having same

    Employee name ("Employee1 ","Employee 2")

    Through which i can get all the owners ,tables , columns which are having that Data

    ("Employee1 ","Employee 2")