SQL> select n1, o1, n2, o2 from v_doublons67; N1 O1 N2 O2 ---------- ---------- ---------- ---------- 1984048 1 2005070 2 1988013 1 2008012 2 1986011 1 2005041 1 1982017 1 2000101 1 1980029 1 1998099 2 1985022 1 2003065 1 1989012 1 2006091 1 1985039 1 2003040 2 1985023 1 2002087 2 1989051 1 2006089 2 1984014 1 2001006 1 1986038 1 2003015 1 1992026 1 2008067 1 1990010 1 2006019 1 1990044 1 2006082 2 1990051 1 2006069 2 1981052 1 1997004 2 1976027 1 1991043 2 1988018 1 2002031 2 1993031 1 2007002 1 1985011 1 1996067 2 1997021 2 2008063 2 1985023 1 1994003 2 1978036 1 1987010 1 1991014 2 1999009 1 1992025 1 1999072 1 1996008 1 2002098 1 1992012 2 1998019 2 1986049 1 1992037 1 1999100 2 2005057 2 1987035 1 1992037 1 1993029 1 1996078 1 1990036 1 1993038 1 1987013 1 1990004 1 1998025 1 2001002 2 1989040 1 1992016 1 1996039 1 1998092 2 1993031 2 1995042 1 1991035 2 1993007 1 2000065 2 2001099 1 1995040 2 1996071 2 1999022 2 2000003 2 2004057 1 2004073 2 2007020 1 2007028 2 44 rows selected. SQL> spool off -- -- Exemple de la derniere ligne -- SQL> select n, date_tirage, o, mesa, t, complementaire from v_tirages where (n=2007020 and o=1) or (n=2007028 and o=2); N DATE_TIRA O ME T COMPLEMENTAIRE ---------- --------- ---------- -- -------------------- -------------- 2007028 07-APR-07 2 SA 10-12-20-24-28-42 36 2007020 10-MAR-07 1 SA 10-15-24-28-36-42 12