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.
declare
num number(5);
begin
num:=#
if num mod 2 =0 then
dbms_output.put_line('Accepted Number '||num||' is even');
else
dbms_output.put_line('Accepted Number '||num||' is odd');
end if;
end;
Implicit Cursor & Explicit Cursor
Implicit Cursor are declared and used by the oracle internally oracle automatically opens and closes the cursor .Where as the explicit cursors…Read More
Raise Application_Error
What is Raise Application_Error
The procedure RAISE_APPLICATION_ERROR lets user to issue user-defined ORA- error messages from stored subprograms. …Read More
nested Procedure
In general, something that is nested is fully contained within something else of the same kind.
In programming, nested describes code that perform…Read More
0 comments:
Post a Comment