Home » SQL & PL/SQL » SQL & PL/SQL » How to find out present text as well not present (Oracle 10g)
How to find out present text as well not present [message #402940] Wed, 13 May 2009 04:27 Go to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

SELECT referenced_name AS "Object Name",
       NAME            AS "Reference Name"
FROM   user_dependencies
WHERE  referenced_name IN
       (fff, 'SF', 'yyyyy',
        'TEST', 'GHP_OPG', 'GHHH');


I want the name list those pesent in the given IN .
AS well I also want those name not present in the view.
HOw can I find out this ?
Re: How to find out present text as well not present [message #402946 is a reply to message #402940] Wed, 13 May 2009 04:35 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Please describe what you want to achieve and scenario in detail to provide you better help

regards,
Delna

[Updated on: Wed, 13 May 2009 04:41]

Report message to a moderator

Re: How to find out present text as well not present [message #402949 is a reply to message #402940] Wed, 13 May 2009 04:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
outer join with dba_objects.

Regards
Michel
Re: How to find out present text as well not present [message #402987 is a reply to message #402949] Wed, 13 May 2009 06:05 Go to previous messageGo to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

I write this query but it doesnt give me proper output.SP_TEST is the name of my procedure that is presnet in the user_objects
but not in ser_dependencies.I dnot have access to DBA_OBJECTS

SELECT uo.object_name,
       ud.NAME,
       ud.referenced_name
FROM   user_dependencies ud,
       user_objects      uo
WHERE  ud.referenced_name = 'SP_TEST'
AND     uo.object_name=ud.referenced_name
Re: How to find out present text as well not present [message #402990 is a reply to message #402987] Wed, 13 May 2009 06:11 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 13 May 2009 11:45
outer join with dba_objects.

Regards
Michel


Previous Topic: SQL Query to Update and retrieve the records
Next Topic: dropping the tables
Goto Forum:
  


Current Time: Wed Dec 07 22:08:55 CST 2016

Total time taken to generate the page: 0.15243 seconds