SQL program for high level language extension with explict cursor

       HIGHLEVEL LANGUAGE EXTENSION

WITH EXPLICIT CURSOR

AIM:

  To write a PL/SQL program for high level language extension with explict cursor

ALGORITHM:

                        Step 1:  Start the program

                        Step 2: create a cursor named c1 & store c divided row wise in r1

Step 3 : fetch c1 into √1 until √1 value found 

Step 4 : print the value of student no & student name

Step 5: display the value of a as result

Step 6 : Stop the program

          

PROGRAM:

Sql > set server output on

                        Sql> 1  declare

                        2  cursor cl is select * from jumbo;

                        3  r1 cl % rowtype;

                        4  begin

                        5  open cl;

                        6  loop

                        7  fetch cl into r1;

                        8  dbms_output.put_line(r1.dept||''||r1.name)

                        9  exit when cl% notfound ;

                        10  end loop;

                        11  close cl;

                        12* end;

OUTPUT:

Eee  sandy

Cse  sathees

Cse  sathees

PL/SQL procedure successfully completed.

Posted in: MySQL