diff options
| author | Gaspard Coulet <gaspard.coulet@mines-ales.org> | 2021-04-28 23:05:53 +0200 |
|---|---|---|
| committer | Gaspard Coulet <gaspard.coulet@mines-ales.org> | 2021-04-28 23:05:53 +0200 |
| commit | 9fe033ea88c2f705ec18c232873d056e0c229d72 (patch) | |
| tree | 0647dc8c51610c7336c88c04de2068ea14b21e17 /sem_5/HLIN511_BDD/tp4.sql | |
Initial commit
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; +/ |