Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to structure prodecure
Why can't you sort them as part of the cursor def.?
Matthew Rogers wrote:
> For the below problem, I'm using Oracle 8i and PL/SQL. My goal is to
> calculate a students GPA then display the top 3 for the entire class. My
> GPA function is called within my displayTop3GPA() stored procedure. I can
> display all records by using a cursor, but how can I sort them? Since none
> of the GPA data is static, I'm somewhat confused.
>
> What I have tried is placing the data inside a nested table, but nested
> tables can't have more than 1 column, AND you can't apply SELECT statements
> to them.
>
> The next thing I tried is creating a dynamic table and storing the
> information there, then sorting it, BUT I don't have access to create a
> table within a stored procedure.
>
> How can I sort my dynamically generated data? Any suggestions are welcome.
>
> Thanks,
>
> Matt
Received on Thu Mar 29 2001 - 13:25:40 CST