SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 18 11:40:40 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 5.1 ---

NOMC
--------------------
Asterix
Donald
Donald
GrosseBaf
Jerry
La Castafiore
Mafalda
Milou
Milou
Nestor Burma
Ordralphabetix

NOMC
--------------------
Ordralphabetix
Picsou
Picsou
Picsou
Stella

16 rows selected.

--- Requete 5.2 ---

	NC	 PRIX
---------- ----------
	10	  617
	 9	  570
	 5	  274
	 6	  252
	 7	  250
	 8	  214
	11	  200
	 4	  127
	 2	  116
	 1	  116
	 3	  104

11 rows selected.

--- Requete 5.3 ---

VDEP			     NC
-------------------- ----------
Paris			      1
Paris			      2
Paris			      3
Paris			      4
Lyon			      5
Paris			      6
Quiberon		      7
Clermont Ferrand	      8
Paris			      9
Shannon 		     10
Barcelone		     11

11 rows selected.

--- Requete 6.1 ---

NOMC
--------------------
Picsou
Mafalda
Donald

--- Requete 6.2 ---

NOMC
--------------------
La Castafiore
Jerry
Ordralphabetix
Stella

--- Requete 6.3 ---

NOMC
--------------------
Stella

--- Requete 7.1 ---

NOMC
--------------------
GrosseBaf
Picsou
La Castafiore
Jerry
Ordralphabetix

--- Requete 7.2 ---

	NC
----------
	 5
	 6
	 7
	 7
	 7
	 7
	 7
	 8
	 8
	 8
	 2

	NC
----------
	 2
	 2
	 2
	 2
	10
	10
	10
	10
	10
	10
	10

22 rows selected.

--- Requete 7.3 ---

	NR	   NC
---------- ----------
	 3	    1
	16	    4
	18	    1
	 8	    8
	 9	    8
	10	    2
	11	    3
	20	    5
	26	   10

9 rows selected.

--- Requete 7.4 ---

	NC DATEDEP	  NBRES
---------- --------- ----------
	 9 08-JAN-05	     10
	 8 25-MAR-04	      1
	 1 29-SEP-04	     10

--- Requete 7.5 ---

NOMV
--------------------
Port Cotton
Port Maria

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