Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- v_letiste number;
- BEGIN
- select airports into v_letiste
- from wf_countries
- where country_name='Navassa Island';
- CASE
- when v_letiste <=100 then dbms_output.put_line('There are 100 nebo min letist');
- when v_letiste between 101 and 1000 then dbms_output.put_line('There are 101 az 1000 letist');
- when v_letiste between 1001 and 10000 then dbms_output.put_line('There are 1001 az 10k letist');
- when v_letiste >10000 then dbms_output.put_line('There are vic jak 10k');
- ELSE dbms_output.put_line('There are 0 letist');
- END CASE;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement