Advertisement
Guest User

Untitled

a guest
Oct 20th, 2014
216
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. DECLARE
  2. v_letiste number;
  3. BEGIN
  4. select airports into v_letiste
  5. from wf_countries
  6. where country_name='Navassa Island';
  7. CASE
  8. when v_letiste <=100 then dbms_output.put_line('There are 100 nebo min letist');
  9. when v_letiste between 101 and 1000 then dbms_output.put_line('There are 101 az 1000 letist');
  10. when v_letiste between 1001 and 10000 then dbms_output.put_line('There are 1001 az 10k letist');
  11. when v_letiste >10000 then dbms_output.put_line('There are vic jak 10k');
  12. ELSE dbms_output.put_line('There are 0 letist');
  13. END CASE;
  14. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement