Re: How to export stored procedures

phil chang wrote:
>
> Actually, you have to:
>
> select text
> from user_source
> order by
> name,
> type,
> line;
>

Actually you don't. (At least in the versions of Oracle I'm using 7.2.2.3, 7.3.2.3).
The explain plan for the view looks like:   SELECT STATEMENT
    NESTED LOOPS

      TABLE ACCESS BY ROWID OBJ$
        INDEX RANGE SCAN I_OBJ2
      TABLE ACCESS BY ROWID SOURCE$
        INDEX RANGE SCAN I_SOURCE1

... and looking at those two indexes...
I_OBJ2 indexes by OWNER#,NAME, etc
I_SOURCE1 indexes by OBJ#,LINE

so the data will be retreieved in Object, line order anyway. (and package bodies/headers are separate objects).

Thought I guess it is foolish to _rely_ on these indexes being like that, so I s'pose you're right :o)

        Brian. Received on Tue Jun 17 1997 - 00:00:00 CDT