Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    17

    Unanswered: query to find column in views

    Hi All,

    i want to know some thing bout finding a particular column used in views.
    like to find out a column in a tables we have view like all_tab_clos/dba_tab_cols ,
    is there anything like this, to find column 'X' used in N no of views.


    Thanks in advance,
    Lucky.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Code:
    select B.VIEW_NAME
    from ALL_VIEWS B,all_tab_columns A
    where A.column_name = 'X'
    AND A.OWNER = B.OWNER
    AND A.TABLE_NAME = B.VIEW_NAME
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jul 2008
    Posts
    11
    by flowwing query u can see all column name of table


    desc table_name

  4. #4
    Join Date
    Jun 2009
    Posts
    17
    hi friends,

    thanks for the reply.

    query was useful.

    Lucky.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •