Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where is line 21? ++ USER_TRIGGERS vs USER_SOURCE
Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<cndi90$moj$1_at_news4.zwoll1.ov.home.nl>...
> Rauf Sarwar wrote:
>
> [snip]
> >
> > SQL> select text from user_source where name = 'FOO' and line = 6;
> >
> > TEXT
> > --------------------------------------------------------------------------------
> > dbms_output.put_line('This is line 6 NOT OK';
> >
>
> What's wrong with L6?
> SQL*Plus reference:
> L[IST] [ n | n m | n * | n LAST | * | * n | * LAST | LAST]
Nothing wrong with it.. I use it all the time. My post was in response to user_source usage as discussed by others in this thread... plus this command is relevant to SQL*Plus only.
Regards
/Rauf
Received on Wed Nov 17 2004 - 03:46:52 CST