Cursor In Oracle .What is Cursor?
it is a pointer to this context area. Oracle creates context area for processing an SQL statement which contains all information about the statement.
Monday, August 20, 2012
WRITE A PROGRAM TO FIND SUM OF NUMBERS FROM 1 TO 100
-- WRITE A PROGRAM TO FIND SUM OF NUMBERS FROM 1 TO 100
DECLARE
N NUMBER(3):=1;
S NUMBER(4):=0;
BEGIN
WHILE N<=10
LOOP
S := S+N;
N :=N+1;
END LOOP;
DBMS_OUTPUT.PUT_LINE('THE SUM IS '||S);
END;
0 comments:
Post a Comment