Set serveroutput on;
declare
counter NUMBER;
n number := &n;
begin
counter := 0;
for i in 2..n LOOP
for j in 2..i LOOP
if mod(i,j)=0 then
DBMS_OUTPUT.PUT_LINE(i||’ Not a PRIME’);
COUNTER:=1;
exit;
end if;
end loop;
IF (counter = 0) THEN
DBMS_OUTPUT.PUT_LINE(i||’ PRIME’);
END IF;
end loop;
end;
/
set serveroutput on; declare a number:=&a; begin for i in 1..a loop for j in 1..i loop dbms_output.put(‘*’); end...
Basic Loop Set serverouput on; DECLARE v_no NUMBER := &no; f NUMBER := 1; n_temp NUMBER; BEGIN n_temp:= v_no;...
While Loop : Set Serveroutput On; DECLARE v_no NUMBER := &no; f NUMBER := 1; n_temp NUMBER; BEGIN n_temp...
A cursor is a pointer to an area in the memory. It is specific temporary work area for a...
For Loop: Set serveroutput on; declare v_no number(4):=&b; f number(4):=1; begin for i in 1..v_no loop f:=f*i; end loop;...
What is SQL ? SQL is Structured Query Language, It is an interface between user and relational database. For...
Difference Functions Procedure 1 A function always returns a value. 1 A procedure may or may not return a...
©2023 MYBSCIT.com. An initiative by some failures to make student scholars.
