Advertisement
Guest User

Untitled

a guest
Nov 21st, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. declare
  2. cursor curCli is select numero_cli, count(*) from Commandes where date_cde between '21/11/09' and sysdate group by numero_cli order by 2 desc;
  3. tabCli curCli%rowtype;
  4. cpt number;
  5.  
  6. begin
  7. cpt := 0;
  8. open curCli;
  9. if curCli%isopen then
  10. while cpt < 3 loop
  11. fetch curCli into tabCli;
  12. dbms_output.put_line(tabCli.numero_cli);
  13. cpt := cpt + 1;
  14. end loop;
  15. end if;
  16. close curCli;
  17. end;
  18. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement