Oracle 9i:Download example SQL Scripts used in Tutorials

sonunag said:

DECLARE
N NUMBER:=1;
BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE (N);
N := N + 1;
EXIT When N>5;
END LOOP;
END;
/

May 10, 2005

sonunag said:

DECLARE
N NUMBER:=1;
BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE (N);
N := N + 1;
EXIT When N>5;
END LOOP;
END;
/

May 10, 2005

declare
flag number :=0;
n number;
i number;
begin
n:=&n;
for i in 2..(n-1) loop
if (n mod i)=0 then
flag:=1;
end if;

end loop;

if flag=1 then
dbms_output.put_line('not a prime');
else
dbms_output.put_line( 'is a prime');
end if;

end;

December 14, 2006

neelu.payola said:

declare
a number:=0;
b number:=1;
c number;
n number;
begin
n:=&n;
for i in 1..n loop
c:=a b;
a:=b;
b:=c;
dbms_output.put_line(c);
end loop;
end;

December 14, 2006

Aritra Chattopadhyay said:

Great :)

March 09, 2007

manu_oracleapps said:

DECLARE
CURSOR C1 IS SELECT * FROM EMP;
EMP_REC EMP%ROWTYPE;
BEGIN
OPEN C1;

LOOP
FETCH C1 INTO EMP_REC;
DBMS_OUTPUT.PUT_LINE(EMP_REC.EMPNO ||' '||EMP_REC.ENAME ||' '||EMP_REC.SAL);
EXIT WHEN C1%ROWCOUNT >10;
END LOOP;
CLOSE C1;
END;

May 06, 2008

Tags

sonunag said:

sonunag said:

neelu.payola said:

neelu.payola said:

Aritra Chattopadhyay said:

manu_oracleapps said: