This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Using user_source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Using user_source" Watch "Using user_source" New topic
Author

Using user_source

Sudarshan Sreenivasan
Ranch Hand

Joined: Jun 28, 2007
Posts: 188

Hi,

I want to user the user_source view to find out all the say 'procs' which have inserted a value in a column named effto in my database




The above query may work but will fail if insert and effto where in different lines in the proc.

Can anyone suggest a query that can help me retrieve the required rows ?
Sudarshan Sreenivasan
Ranch Hand

Joined: Jun 28, 2007
Posts: 188



This is what i was looking for

Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using user_source
 
Similar Threads
Meta Data for Oracle Store Procedures?
Database Metadata
View Stored Procedure
Viewing Stored Procedure in SQL plus
Search query is taking too long to search