This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one 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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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