Re: beginner: on a related note....cursors

On 10 avr, 08:54, "matt" <reflectio..._at_gmail.com> wrote:
> I have put together the following plsql and can verify that it does
> return the expected result..."the closest existing salary to a user
> entered salary of 8000"
> The problem i face with this having to make this a stored procedure or
> function without whole-sale changes. Any ideas? The required use of
> a cursor makes this especially challenging for me.
>
> DECLARE
> name empbb02.ename%TYPE;
> salary empbb02.sal%TYPE;
> TYPE cursor_var IS REF CURSOR;
> myCursorVar cursor_var;
> TargetSalary empbb02.sal%TYPE;
> rk number(5);
>
> BEGIN
>
> OPEN myCursorVar FOR SELECT RANK()OVER(ORDER BY ABS(E.sal - 8000))AS
> RNK, E.ename
> , E.sal
> FROM empbb02 E;
>
> LOOP
> FETCH myCursorVar INTO rk, name,salary;
> EXIT WHEN myCursorVar%NOTFOUND OR rk ='2';
> DBMS_OUTPUT.PUT_LINE(rk||' '||name||' '||salary);
> END LOOP;
> CLOSE myCursorVar;
> END;
> /

Dear Matt, please allow me a few comments :

1. This group is more oriented toward oracle administration discussions. Questions like the above would be more on-topic in comp.databases.oracle.misc.
2. People posting here are experts (not me :-). They will gladly help, but they - rightly - require that documentation has been read and research has been performed before a question is asked.
3. One way to start with Oracle is to read the concept manual from top to bottom, and from there to move on to some other manuals - eg the PL/SQL User's Guide and Reference. The documentation is freely available at http://tahiti.oracle.com/
4. A great resource to search for is http://asktom.oracle.com/ eg http://asktom.oracle.com/tkyte/ResultSets/index.html

Hope it helps. Have a very nice day

• Raoul