diff options
Diffstat (limited to 'sem_5/HLIN511_BDD/tp4.sql')
| -rw-r--r-- | sem_5/HLIN511_BDD/tp4.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sem_5/HLIN511_BDD/tp4.sql b/sem_5/HLIN511_BDD/tp4.sql new file mode 100644 index 0000000..e98fd7c --- /dev/null +++ b/sem_5/HLIN511_BDD/tp4.sql @@ -0,0 +1,11 @@ +declare +cursor c is select num_ab,count(num_ex) as nb_emprunt from Emprunt group by num_ab; +begin +for c_t in c +loop +insert into ab_nb values (c_t.num_ab,c_t.nb_emprunt); +end loop; +exception when no_data_found +insert into ab_nb values (c_t.num_ab,-1); +end; +/ |