Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Beginner: Procedure Help
One word of caution when using USER_ tables: The view that you will access
will be based on the owner of the procedure. i.e. If the user SCOTT owns the
procedure, the results will be for user SCOTT only. If you want this procedure
to be universal, use DBA_ tables where owner = user.
Received on Tue Jan 26 1999 - 13:45:41 CST