1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Select nomdossier From Dossier Where id_dossier = 12500;
Select nomdossier From Dossier Where nomdossier like 'PC%';
Select count(distinct nomdossier) From Dossier Where nomdossier like 'PC%';
Select count(distinct nomdossier) From Dossier D, Modele M Where D.id_modele = M.id_modele And M.codeADS = 'PC';
Select count(*) From
( Select d.id_dossier, nomdossier
From Dossier D, DossierEtat DE
Where D.id_dossier = DE.id_dossier (+)
And (DE.id_etat = 2 or DE.id_etat is null));
Select distinct D.Id_dossier, DE1.DateLimiteLegale , DE1.DateLimitePrevue , DE1.DateEffective , DE2.DateLimiteLegale , DE2.DateLimitePrevue , DE2.DateEffective , DE3.DateLimiteLegale , DE3.DateLimitePrevue , DE3.DateEffective , DE4.DateLimiteLegale , DE4.DateLimitePrevue , DE4.DateEffective
From Dossier D , DossierEtat DE1 , DossierEtat DE2 , DossierEtat DE3 , DossierEtat DE4
Where D.id_dossier in
( Select distinct DE.id_dossier from DossierEtat DE, Dossier VLD where DE.id_dossier = VLD.id_dossier and VLD.CodeADS = 'PC' And id_etat = 1
and DateEffective between to_date('01/12/2002','DD/MM/YYYY') and to_date('01/01/2003','DD/MM/YYYY')
And DE.id_dossier in
(Select DE.id_dossier from dossieretat DE where id_etat = 30 and DateEffective between to_date('01/12/2002','DD/MM/YYYY')
and to_date('01/01/2003','DD/MM/YYYY')
and DE.id_dossier not in
(select id_dossier from dossieretat where id_etat = 150 and DateEffective is not null)
and DE.id_dossier not in
(select id_dossier from dossieretat where id_etat = 152 and DateEffective is not null) ) )
And D.Id_Dossier = DE1.Id_Dossier (+) And DE1.id_etat (+) = 1 And D.Id_Dossier = DE2.Id_Dossier (+)
And DE2.id_etat (+) = 30 And D.Id_Dossier = DE3.Id_Dossier (+) And DE3.id_etat (+) = 150
And D.Id_Dossier = DE4.Id_Dossier (+) And DE4.id_etat (+) = 152 Order By DE1.DateEffective; |
Partager