Home » SQL & PL/SQL » SQL & PL/SQL » help to search text in package (SQL,10,XP)
help to search text in package [message #300429] Fri, 15 February 2008 06:41 Go to next message
aadebayo
Messages: 35
Registered: August 2005
Member
Please can someone tell me how to search for explicit texts within a package.
for example if I have the following code

CURSOR c_incident_type(cp_incident_id IN cs_incidents_v.incident_id%TYPE) IS
      SELECT CITV.incident_type_id as incident_type_id,
             CITL.name as name,
             CITV.attribute1 as pid,
             CITV.attribute2 as secondary_pid,
             CITV.attribute4 as authentication_level,
             CITV.attribute15 as lob,
             CITV.attribute14 as keywords,
             CSIB.incident_id as incident_id,
             CSIA.incident_number as incident_number,
             CSIB.summary as summary,
             CSSB.name as status,
             to_char(CSIA.incident_date, 'DD-MON-YYYY HH24:MI:SS') as incident_date,
             NVL(CITV.attribute12, 'N') as required,
             NVL(HZL.location_id, '0') as location_id,
             NVL(HZL.address1, '') as street,
             NVL(HZL.address2, '') as locality,



how do I search for objects containing
CITV.attribute1 as pid,
CITV.attribute2 as secondary_pid,
CITV.attribute4 as authentication_level,



Ade
Re: help to search text in package [message #300430 is a reply to message #300429] Fri, 15 February 2008 06:43 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You can Select from dictionary view user_source with the appropriate

... where text like '%sometext%'


clause.
Re: help to search text in package [message #300434 is a reply to message #300430] Fri, 15 February 2008 06:54 Go to previous message
aadebayo
Messages: 35
Registered: August 2005
Member
Thanks very much
Previous Topic: How to assign record count to a variable
Next Topic: Top-N query
Goto Forum:
  


Current Time: Sat Dec 03 16:29:50 CST 2016

Total time taken to generate the page: 0.22830 seconds