Procedure to find out odd number between 1 to 30 | Query odd number between 1 to 30 in oracle 19c

Procedure in oracle to find out odd no between 1 to 30 | Query to find out odd no between 1 to 30 in oracle

PROCEDURE:-

set serveroutput on;
/
create or replace procedure odd_number is
i number;
n number;
begin
for i in 1..30 loop
if (mod(i,2)!=0) then
dbms_output.put_line(i);
end if;
end loop;
end;
/
execute odd_number;

#sqlqueries #oracle #oracletutorial #oracleinterviewquestions #plsql #oracletraining

Видео Procedure to find out odd number between 1 to 30 | Query odd number between 1 to 30 in oracle 19c канала Oracle Training-Free Oracle Tutorials