SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 19 15:21:37 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options --- Requete 1.1 --- VILET -------------------- Amsterdam --- Requete 1.2 --- NC ---------- 10 --- Requete 1.3 --- NOMV -------------------- Venise Londres Amsterdam Port Cotton --- Requete 1.4 --- NC VDEP VARR ---------- -------------------- -------------------- 8 Clermont Ferrand Besse 6 Paris Paris 2 Paris Paris 5 Lyon Lyon 7 Quiberon Hoedic 3 Paris Paris 4 Paris Paris 9 Paris Paris 10 Shannon Cork 9 rows selected. --- Requete 1.5 --- NOMM ------------------------------ Madurodam medical Center Canals --- Requete 1.6 --- NC DATEDEP ---------- --------- 2 17-MAR-06 2 17-APR-04 2 16-APR-06 3 11-SEP-06 3 04-MAR-06 2 18-MAR-06 3 11-MAR-06 2 14-NOV-06 8 rows selected. --- Requete 1.7 --- NC NOMC ---------- -------------------- 1 Asterix 1 Picsou 2 Milou 2 Nestor Burma 2 Stella 3 Jerry 4 GrosseBaf 5 Mafalda 5 Ordralphabetix 6 7 Donald NC NOMC ---------- -------------------- 8 La Castafiore 8 Milou 8 Picsou 9 Picsou 10 Donald 10 Ordralphabetix 11 18 rows selected. --- Requete 2.1 --- NB MONUMENTS FRANCAIS --------------------- 3 --- Requete 2.2 --- PRIX MOYEN ---------- 258.181818 --- Requete 2.3 --- NOMC NB RESER -------------------- ---------- La Castafiore 7 Donald 53 GrosseBaf 88 Asterix 4 Stella 11 Jerry 11 Ordralphabetix 4 Milou 100 Picsou 21 Mafalda 43 Nestor Burma 25 11 rows selected. --- Requete 2.4 --- NC ---------- 10 --- Requete 2.5 --- NOMV -------------------- Venise Londres Amsterdam Port Cotton --- Requete 2.6 --- NB MONUMENTS ------------ 3 --- Requete 2.7 --- NOMV NB MONUMENTS -------------------- ------------ Port Maria 1 Port Cotton 2 --- Requete 2.8 --- NOMC MONTANT TOTAL -------------------- ------------- La Castafiore 1498 Donald 13984 GrosseBaf 11176 Asterix 464 Stella 1276 Jerry 1144 Ordralphabetix 1782 Milou 11698 Picsou 7074 Mafalda 11782 Nestor Burma 2900 11 rows selected. --- Requete 2.9 --- MONTANT LE PLUS GRAND --------------------- 13984 --- Requete 2.10 --- NOMC -------------------- Donald --- Requete 2.11 --- NOMC NB MONUMENTS -------------------- ------------ GrosseBaf 3 Donald 3 Asterix 3 Stella 13 Jerry 5 Ordralphabetix 6 Milou 13 Mafalda 6 Picsou 3 Nestor Burma 13 10 rows selected. SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options