1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Table or view does not exist - dba_dependencies

Discussion in 'SQL PL/SQL' started by sania, Oct 15, 2018.

  1. sania

    sania Active Member

    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    india
    Hi Friends,

    I am trying to retrieve all views which are using a particular function.
    But when I run the statement -

    SELECT *
    FROM DBA_DEPENDENCIES


    it throws error - table or view does not exist. Am I missing something in query? Kindly help.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,645
    Likes Received:
    370
    Trophy Points:
    1,430
    Location:
    Aurora, CO