Click here to Skip to main content
15,918,808 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
hello,,
i'm new in oracle .. can you please help me to solve this?

Write a PL/SQL block to display the multiples of a Given Number without including multiples of 10 for a given range (Start Value and End Value), using GOTO.

Note: The user will input the values for Start value, end value and Given Number

Example :

Start value: 1
End Value: 100
Given Number: 5
5
15
20
..
100

i tried to solve it .. but i couldn't get the correct answer.
please help ^^ ... thanks
Posted
Comments
DamithSL 1-Jun-15 14:18pm    
can you update the question with the script you tried?

1 solution

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!
 
Share this answer
 
Comments
Member 11193774 5-Jun-15 13:57pm    
actually ,, i tried to solve it ,, but really i couldn't get the solution :'(
this is my solution :
declare
start_value number; end_value number; n number;
result;
begin
start_value:=&start_value;
end_value:=&end_value;
n :=&n;
for x in start_value..end_value loop
<<calc>>
if((x mod n)=0 and (x mod 10)!=0) then
dbms_output.put_line(x);
end if;
goto calc;
end loop;
end;
/

.. i couldn't place goto statement in correct place ,, please help me ^^

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900