GeeCON Prague 2014*
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


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