1.
    SELECT *
    FROM BIEN
    WHERE TO_CHAR(DATE, 'mmyyy') = 082012;

2.
    SELECT *
    FROM BIEN
    WHERE NB_CHAC > 4;

3.
    SELECT *
    FROM BIEN
    WHERE UPPER(LOCALITE) <> 'VERVIERS';


4.
    SELECT *
    FROM CANDIDATS
    WHERE REGEXP_LIKE (nom, '\w*on\w*')

5.
    SELECT *
    FROM CANDIDAT
    WHERE EMAIL IS NULL;

6.
    SELECT *
    FROM OFFRE
    WHERE TO_CHAR(DATE_OFFRE, 'yyyymmdd') < TO_CHAR(SYSDATE, 'yyyymmdd');

7.
    SELECT *
    FROM VENDEUR
    WHERE PASSWORD IS NULL OR LOGIN IS NULL;

8.
    SELECT bi.*
    FROM BIEN bi
    JOIN OFFRE o ON bi.id_bien = o.ID_BIEN
    ORDER BY bi.id_bien ASC;

9.
    SELECT id_bien, MOD(TO_NUMBER(TO_CHAR(SYSDATE, 'yyyymmdd')) - TO_NUMBER(TO_CHAR(DATE_MISE_EN_VENTE, 'yyyymmdd')),
                TO_NUMBER(TO_CHAR(SYSDATE, 'yyyy')) - TO_NUMBER(TO_CHAR(DATE_MISE_EN_VENTE, 'yyyy')))
    FROM BIEN;