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!

user_dependencies

Discussion in 'SQL PL/SQL' started by kaldenecker, Oct 27, 2011.

  1. kaldenecker

    kaldenecker Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    SQL> desc user_dependencies;
    SQL> select name, type,
    2 referenced_name, referenced_type
    3 from user_dependencies
    4 where name = 'EMP_MAINT'
    5 /
     
  2. kaldenecker

    kaldenecker Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Delivered Packages;
    SQL> select object_name
    2 from dba_objects
    3 where owner = 'SYS'
    4 and object_type = 'PACKAGE';
     
  3. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Nice Query :)
    What are you expecting from this query ?
     
  4. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Lol... I really don't understand why some people make such posts and say nothing about it... :)
     
  5. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    They are 'dispensing knowledge' -- likely such posts are 'hit-and-run' offerings and the original poster does not return.