IdentifiantMot de passe
Mot de passe oublié ?Je m'inscris ! (gratuit)
Navigation

Inscrivez-vous gratuitement
pour pouvoir participer, suivre les réponses en temps réel, voter pour les messages, poser vos propres questions et recevoir la newsletter

PL/SQL Oracle Discussion :

Suppression des clés JSON avec une certaine chaîne de caractères en PL/SQL


Sujet :

PL/SQL Oracle

Vue hybride

Message précédent Message précédent   Message suivant Message suivant
  1. 05/12/2023, 17h49 #1
    LandGreen
    LandGreen est déconnecté
    Membre très actif
    Homme Profil pro
    Développeur informatique
    Inscrit en
    Février 2018
    Messages
    454
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : Algérie

    Informations professionnelles :
    Activité : Développeur informatique
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Février 2018
    Messages : 454
    Par défaut Suppression des clés JSON avec une certaine chaîne de caractères en PL/SQL
    Actuellement engagé dans un projet PL/SQL, je manipule une variable CLOB (vLIGN) au format JSON, où les clés et les valeurs sont concaténées avec "$FUSI$".
    La présence de "$FUSI$" indique que la valeur associée doit être fusionnée avec celle précédente, ce qui équivaut à concaténer les deux valeurs et à supprimer la clé de la dernière occurrence.


    Voici un exemple de ma variable JSON :

    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
     
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 1680000","$FUSI$SALA__PREN":"$FUSI$HADDOCK","NDF__DATE_CREA":"08-04-2022","$FUSI$SALA__NOM":"$FUSI$ CAPITAINE"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 2030000","$FUSI$SALA__PREN":"$FUSI$JEANETTE","NDF__DATE_CREA":"10-02-2022","$FUSI$SALA__NOM":"$FUSI$ DUJARDIN"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 4500000","$FUSI$SALA__PREN":"$FUSI$DECKER","NDF__DATE_CREA":"11-04-2022","$FUSI$SALA__NOM":"$FUSI$ BLACKET"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 200000","$FUSI$SALA__PREN":"$FUSI$DECKER","NDF__DATE_CREA":"11-02-2022","$FUSI$SALA__NOM":"$FUSI$ BLACKET"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 2030000","$FUSI$SALA__PREN":"$FUSI$JAIME","NDF__DATE_CREA":"10-02-2022","$FUSI$SALA__NOM":"$FUSI$ LESGATEAUX"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 200000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"11-02-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 150000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"11-02-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 150000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"11-02-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 7150000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"12-01-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 47815","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"08-04-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 8500000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"11-03-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 194","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"26-08-2021","$FUSI$SALA__NOM":"$FUSI$ IRONE"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 6000000","$FUSI$SALA__PREN":"$FUSI$PARFAIT","NDF__DATE_CREA":"11-01-2022","$FUSI$SALA__NOM":"$FUSI$ MONSIEUR"}
vLIGN={"$FUSI$FRAI__TTC":"$FUSI$ 1773","$FUSI$SALA__PREN":"$FUSI$PARFAIT","NDF__DATE_CREA":"09-03-2022","$FUSI$SALA__NOM":"$FUSI$ MONSIEUR"}
    si on prend la première ligne :
    {"$FUSI$FRAI__TTC":"$FUSI$ 1680000","$FUSI$SALA__PREN":"$FUSI$HADDOCK","NDF__DATE_CREA":"08-04-2022","$FUSI$SALA__NOM":"$FUSI$ CAPITAINE"}

    Elle devrait être transformée en :

    {"FRAI__TTC":"1680000 HADDOCK","NDF__DATE_CREA":"08-04-2022 CAPITAINE"}

    nb : si $FUSI$ est situé au début de la chaîne, il doit être ignoré

    Comment puis-je effectuer cette suppression en utilisant PL/SQL ? J'ai essayé d'utiliser JSON_TRANSFORM avec l'option ON NULL, mais je ne suis pas sûr de la meilleure approche.

    Toute suggestion ou exemple de code serait grandement apprécié. Merci d'avance pour votre aide !
    Répondre avec citation Répondre avec citation   0  0
  2. 06/12/2023, 09h45 #2
    vanagreg
    vanagreg est déconnecté
    Membre Expert
    Homme Profil pro
    Développeur Oracle
    Inscrit en
    Décembre 2019
    Messages
    1 167
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France, Nord (Nord Pas de Calais)

    Informations professionnelles :
    Activité : Développeur Oracle

    Informations forums :
    Inscription : Décembre 2019
    Messages : 1 167
    Par défaut
    Bonjour,

    Le plus simple je pense est de parser le json, supprimer $FUSI$ et concaténer les colonnes, et ensuite regénérer en json. Quelque chose du genre:

    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    with v(text) as (
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 1680000","$FUSI$SALA__PREN":"$FUSI$HADDOCK","NDF__DATE_CREA":"08-04-2022","$FUSI$SALA__NOM":"$FUSI$ CAPITAINE"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 2030000","$FUSI$SALA__PREN":"$FUSI$JEANETTE","NDF__DATE_CREA":"10-02-2022","$FUSI$SALA__NOM":"$FUSI$ DUJARDIN"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 4500000","$FUSI$SALA__PREN":"$FUSI$DECKER","NDF__DATE_CREA":"11-04-2022","$FUSI$SALA__NOM":"$FUSI$ BLACKET"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 200000","$FUSI$SALA__PREN":"$FUSI$DECKER","NDF__DATE_CREA":"11-02-2022","$FUSI$SALA__NOM":"$FUSI$ BLACKET"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 2030000","$FUSI$SALA__PREN":"$FUSI$JAIME","NDF__DATE_CREA":"10-02-2022","$FUSI$SALA__NOM":"$FUSI$ LESGATEAUX"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 200000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"11-02-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 150000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"11-02-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 150000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"11-02-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 7150000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"12-01-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 47815","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"08-04-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 8500000","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"11-03-2022","$FUSI$SALA__NOM":"$FUSI$ IRONE"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 194","$FUSI$SALA__PREN":"$FUSI$MAN","NDF__DATE_CREA":"26-08-2021","$FUSI$SALA__NOM":"$FUSI$ IRONE"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 6000000","$FUSI$SALA__PREN":"$FUSI$PARFAIT","NDF__DATE_CREA":"11-01-2022","$FUSI$SALA__NOM":"$FUSI$ MONSIEUR"}' from dual union all
                select '{"$FUSI$FRAI__TTC":"$FUSI$ 1773","$FUSI$SALA__PREN":"$FUSI$PARFAIT","NDF__DATE_CREA":"09-03-2022","$FUSI$SALA__NOM":"$FUSI$ MONSIEUR"}' from dual
               ) 
select json_object(
                   'FRAI__TTC'      value replace(jt.FRAI__TTC, '$FUSI$') || replace(jt.SALA__PREN, '$FUSI$', ' '),
                   'NDF__DATE_CREA' value jt.NDF__DATE_CREA || replace(jt.SALA__NOM, '$FUSI$')
                  ) text
from v, json_table(text, '$'
                        columns(
                                FRAI__TTC      varchar2(500) path '$."$FUSI$FRAI__TTC"',
                                SALA__PREN     varchar2(500) path '$."$FUSI$SALA__PREN"',
                                NDF__DATE_CREA varchar2(20)  path '$."NDF__DATE_CREA"',
                                SALA__NOM      varchar2(500) path '$."$FUSI$SALA__NOM"'
                               )
                       ) jt;
 
TEXT                                                                            
--------------------------------------------------------------------------------
{"FRAI__TTC":" 1680000 HADDOCK","NDF__DATE_CREA":"08-04-2022 CAPITAINE"}        
{"FRAI__TTC":" 2030000 JEANETTE","NDF__DATE_CREA":"10-02-2022 DUJARDIN"}        
{"FRAI__TTC":" 4500000 DECKER","NDF__DATE_CREA":"11-04-2022 BLACKET"}           
{"FRAI__TTC":" 200000 DECKER","NDF__DATE_CREA":"11-02-2022 BLACKET"}            
{"FRAI__TTC":" 2030000 JAIME","NDF__DATE_CREA":"10-02-2022 LESGATEAUX"}         
{"FRAI__TTC":" 200000 MAN","NDF__DATE_CREA":"11-02-2022 IRONE"}                 
{"FRAI__TTC":" 150000 MAN","NDF__DATE_CREA":"11-02-2022 IRONE"}                 
{"FRAI__TTC":" 150000 MAN","NDF__DATE_CREA":"11-02-2022 IRONE"}                 
{"FRAI__TTC":" 7150000 MAN","NDF__DATE_CREA":"12-01-2022 IRONE"}                
{"FRAI__TTC":" 47815 MAN","NDF__DATE_CREA":"08-04-2022 IRONE"}                  
{"FRAI__TTC":" 8500000 MAN","NDF__DATE_CREA":"11-03-2022 IRONE"}                
{"FRAI__TTC":" 194 MAN","NDF__DATE_CREA":"26-08-2021 IRONE"}                    
{"FRAI__TTC":" 6000000 PARFAIT","NDF__DATE_CREA":"11-01-2022 MONSIEUR"}         
{"FRAI__TTC":" 1773 PARFAIT","NDF__DATE_CREA":"09-03-2022 MONSIEUR"}            
 
14 rows selected.
    Répondre avec citation Répondre avec citation   0  0
  3. 06/12/2023, 09h51 #3
    LandGreen
    LandGreen est déconnecté
    Membre très actif
    Homme Profil pro
    Développeur informatique
    Inscrit en
    Février 2018
    Messages
    454
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : Algérie

    Informations professionnelles :
    Activité : Développeur informatique
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Février 2018
    Messages : 454
    Par défaut
    merci pour votre réponse
    cependant vLIGN est variable et c'est pas en dure, elle peut contenir un nombre non défini de clé-valeur
    c'est à dire on peut avoir plusieurs cas :

    FRAI__TTC , SALA__PREN , SALA__NOM
    ou
    FRAI__TTC , SALA__PREN , SALA__NOM, TVA__SALA
FRAI__TTC , SALA__PREN , SALA__NOM, DATE__NAISS_SALA, DATE__EMBAUCH
FRAI__TTC , SALA__PREN , SALA__NOM, FRAIS__HT, SALA__ADV
....
    Répondre avec citation Répondre avec citation   0  0
  4. 06/12/2023, 09h54 #4
    vanagreg
    vanagreg est déconnecté
    Membre Expert
    Homme Profil pro
    Développeur Oracle
    Inscrit en
    Décembre 2019
    Messages
    1 167
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France, Nord (Nord Pas de Calais)

    Informations professionnelles :
    Activité : Développeur Oracle

    Informations forums :
    Inscription : Décembre 2019
    Messages : 1 167
    Par défaut
    Ah en effet c'est plus compliqué dans ce cas. Tu as quelques exemples avec d'autres chaines?
    Répondre avec citation Répondre avec citation   0  0
  5. 06/12/2023, 10h19 #5
    LandGreen
    LandGreen est déconnecté
    Membre très actif
    Homme Profil pro
    Développeur informatique
    Inscrit en
    Février 2018
    Messages
    454
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : Algérie

    Informations professionnelles :
    Activité : Développeur informatique
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Février 2018
    Messages : 454
    Par défaut
    voici un exemple : ici on peut avoir plusieurs fois FRAI__TTC par exemple, mais il y a d'autres exemples ou j'ai d’autres Clé carrément inexistant ici


    Code json : Sélectionner tout - Visualiser dans une fenêtre à part
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    {"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","NDF__DATE_CREA":"08/04/2022 11:51:00","FRAI__TTC":168}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"09/03/2022 14:36:00","FRAI__TTC":177.3}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"11/01/2022 17:19:00","FRAI__TTC":600}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"26/08/2021 14:11:00","FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/03/2022 09:41:00","FRAI__TTC":850}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"08/04/2022 09:40:00","FRAI__TTC":478.15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"12/01/2022 16:06:00","FRAI__TTC":715}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:33:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:36:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:25:00","FRAI__TTC":20}
{"SALA__NOM":"LESGATEAUX","SALA__PRENOM":"JAIME","NDF__DATE_CREA":"10/02/2022 19:10:00","FRAI__TTC":203}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/02/2022 16:52:00","FRAI__TTC":20}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/04/2022 17:40:00","FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","SALA__PRENOM":"JEANETTE","NDF__DATE_CREA":"10/02/2022 19:08:00","FRAI__TTC":203}
{"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","NDF__DATE_CREA":"08/04/2022 11:51:00","FRAI__TTC":168}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"09/03/2022 14:36:00","FRAI__TTC":177.3}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"11/01/2022 17:19:00","FRAI__TTC":600}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"26/08/2021 14:11:00","FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/03/2022 09:41:00","FRAI__TTC":850}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"08/04/2022 09:40:00","FRAI__TTC":478.15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"12/01/2022 16:06:00","FRAI__TTC":715}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:33:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:36:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:25:00","FRAI__TTC":20}
{"SALA__NOM":"LESGATEAUX","SALA__PRENOM":"JAIME","NDF__DATE_CREA":"10/02/2022 19:10:00","FRAI__TTC":203}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/02/2022 16:52:00","FRAI__TTC":20}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/04/2022 17:40:00","FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","SALA__PRENOM":"JEANETTE","NDF__DATE_CREA":"10/02/2022 19:08:00","FRAI__TTC":203}
{"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","FRAI__DATE_DEPL":"04/04/2022 00:00:00","FRAI__TTC":126}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"12/01/2022 00:00:00","FRAI__TTC":20}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","FRAI__DATE_DEPL":"09/03/2022 00:00:00","FRAI__TTC":4.7}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","FRAI__DATE_DEPL":"07/03/2022 00:00:00","FRAI__TTC":100}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","FRAI__DATE_DEPL":"26/08/2021 00:00:00","FRAI__TTC":38.8}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","FRAI__DATE_DEPL":"21/09/2016 00:00:00","FRAI__TTC":33.8}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","FRAI__DATE_DEPL":"10/01/2022 00:00:00","FRAI__TTC":600}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"26/08/2021 00:00:00","FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"24/02/2022 00:00:00","FRAI__TTC":220}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"21/02/2022 00:00:00","FRAI__TTC":20}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"23/02/2022 00:00:00","FRAI__TTC":500}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"22/02/2022 00:00:00","FRAI__TTC":110}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"06/04/2022 00:00:00","FRAI__TTC":164}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"05/04/2022 00:00:00","FRAI__TTC":72.15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"04/04/2022 00:00:00","FRAI__TTC":242}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"09/03/2022 00:00:00","FRAI__TTC":400}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"07/03/2022 00:00:00","FRAI__TTC":215}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"10/03/2022 00:00:00","FRAI__TTC":80}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","FRAI__DATE_DEPL":"17/01/2022 00:00:00","FRAI__TTC":50}
{"SALA__NOM":"LESGATEAUX","SALA__PRENOM":"JAIME","FRAI__DATE_DEPL":"02/02/2022 00:00:00","FRAI__TTC":203}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","FRAI__DATE_DEPL":"17/01/2022 00:00:00","FRAI__TTC":20}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","FRAI__DATE_DEPL":"07/04/2022 00:00:00","FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","SALA__PRENOM":"JEANETTE","FRAI__DATE_DEPL":"01/02/2022 00:00:00","FRAI__TTC":203}
{"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","FRAI__DATE_DEPL":"05/04/2022 00:00:00","FRAI__TTC":42}
{"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","NDF__DATE_CREA":"08/04/2022 11:51:00","FRAI__TTC":168}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"09/03/2022 14:36:00","FRAI__TTC":177.3}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"11/01/2022 17:19:00","FRAI__TTC":600}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"26/08/2021 14:11:00","FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/03/2022 09:41:00","FRAI__TTC":850}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"08/04/2022 09:40:00","FRAI__TTC":478.15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"12/01/2022 16:06:00","FRAI__TTC":715}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:33:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:36:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:25:00","FRAI__TTC":20}
{"SALA__NOM":"LESGATEAUX","SALA__PRENOM":"JAIME","NDF__DATE_CREA":"10/02/2022 19:10:00","FRAI__TTC":203}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/02/2022 16:52:00","FRAI__TTC":20}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/04/2022 17:40:00","FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","SALA__PRENOM":"JEANETTE","NDF__DATE_CREA":"10/02/2022 19:08:00","FRAI__TTC":203}
{"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","NDF__DATE_CREA":"08/04/2022 11:51:00","FRAI__TTC":168}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"09/03/2022 14:36:00","FRAI__TTC":177.3}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"11/01/2022 17:19:00","FRAI__TTC":600}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"26/08/2021 14:11:00","FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/03/2022 09:41:00","FRAI__TTC":850}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"08/04/2022 09:40:00","FRAI__TTC":478.15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"12/01/2022 16:06:00","FRAI__TTC":715}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:33:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:36:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:25:00","FRAI__TTC":20}
{"SALA__NOM":"LESGATEAUX","SALA__PRENOM":"JAIME","NDF__DATE_CREA":"10/02/2022 19:10:00","FRAI__TTC":203}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/02/2022 16:52:00","FRAI__TTC":20}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/04/2022 17:40:00","FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","SALA__PRENOM":"JEANETTE","NDF__DATE_CREA":"10/02/2022 19:08:00","FRAI__TTC":203}
{"SALA__NOM":"CAPITAINE","NDF__DATE_CREA":"08/04/2022 11:51:00","FRAI__TTC":168}
{"SALA__NOM":"MONSIEUR","NDF__DATE_CREA":"09/03/2022 14:36:00","FRAI__TTC":177.3}
{"SALA__NOM":"MONSIEUR","NDF__DATE_CREA":"11/01/2022 17:19:00","FRAI__TTC":600}
{"SALA__NOM":"IRONE","NDF__DATE_CREA":"26/08/2021 14:11:00","FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","NDF__DATE_CREA":"11/03/2022 09:41:00","FRAI__TTC":850}
{"SALA__NOM":"IRONE","NDF__DATE_CREA":"08/04/2022 09:40:00","FRAI__TTC":478.15}
{"SALA__NOM":"IRONE","NDF__DATE_CREA":"12/01/2022 16:06:00","FRAI__TTC":715}
{"SALA__NOM":"IRONE","NDF__DATE_CREA":"11/02/2022 16:33:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","NDF__DATE_CREA":"11/02/2022 16:36:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","NDF__DATE_CREA":"11/02/2022 16:25:00","FRAI__TTC":20}
{"SALA__NOM":"LESGATEAUX","NDF__DATE_CREA":"10/02/2022 19:10:00","FRAI__TTC":203}
{"SALA__NOM":"BLACKET","NDF__DATE_CREA":"11/02/2022 16:52:00","FRAI__TTC":20}
{"SALA__NOM":"BLACKET","NDF__DATE_CREA":"11/04/2022 17:40:00","FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","NDF__DATE_CREA":"10/02/2022 19:08:00","FRAI__TTC":203}
{"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","NDF__DATE_CREA":"08/04/2022 11:51:00","FRAI__TTC":168}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"09/03/2022 14:36:00","FRAI__TTC":177.3}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"11/01/2022 17:19:00","FRAI__TTC":600}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"26/08/2021 14:11:00","FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/03/2022 09:41:00","FRAI__TTC":850}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"08/04/2022 09:40:00","FRAI__TTC":478.15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"12/01/2022 16:06:00","FRAI__TTC":715}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:33:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:36:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:25:00","FRAI__TTC":20}
{"SALA__NOM":"LESGATEAUX","SALA__PRENOM":"JAIME","NDF__DATE_CREA":"10/02/2022 19:10:00","FRAI__TTC":203}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/02/2022 16:52:00","FRAI__TTC":20}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/04/2022 17:40:00","FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","SALA__PRENOM":"JEANETTE","NDF__DATE_CREA":"10/02/2022 19:08:00","FRAI__TTC":203}
{"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","NDF__DATE_CREA":"08/04/2022 11:51:00","FRAI__TTC":168}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"09/03/2022 14:36:00","FRAI__TTC":177.3}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"11/01/2022 17:19:00","FRAI__TTC":600}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"26/08/2021 14:11:00","FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/03/2022 09:41:00","FRAI__TTC":850}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"08/04/2022 09:40:00","FRAI__TTC":478.15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"12/01/2022 16:06:00","FRAI__TTC":715}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:33:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:36:00","FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:25:00","FRAI__TTC":20}
{"SALA__NOM":"LESGATEAUX","SALA__PRENOM":"JAIME","NDF__DATE_CREA":"10/02/2022 19:10:00","FRAI__TTC":203}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/02/2022 16:52:00","FRAI__TTC":20}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/04/2022 17:40:00","FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","SALA__PRENOM":"JEANETTE","NDF__DATE_CREA":"10/02/2022 19:08:00","FRAI__TTC":203}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"12/01/2022 16:06:00","FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:33:00","FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:36:00","FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:25:00","FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20}
{"SALA__NOM":"LESGATEAUX","SALA__PRENOM":"JAIME","NDF__DATE_CREA":"10/02/2022 19:10:00","FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/02/2022 16:52:00","FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/04/2022 17:40:00","FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","SALA__PRENOM":"JEANETTE","NDF__DATE_CREA":"10/02/2022 19:08:00","FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203}
{"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","NDF__DATE_CREA":"08/04/2022 11:51:00","FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"09/03/2022 14:36:00","FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"11/01/2022 17:19:00","FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"26/08/2021 14:11:00","FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/03/2022 09:41:00","FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"08/04/2022 09:40:00","FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15}
{"SALA__NOM":"CAPITAINE","SALA__PRENOM":"HADDOCK","NDF__DATE_CREA":"08/04/2022 11:51:00","FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168,"FRAI__TTC":168}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"09/03/2022 14:36:00","FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3,"FRAI__TTC":177.3}
{"SALA__NOM":"MONSIEUR","SALA__PRENOM":"PARFAIT","NDF__DATE_CREA":"11/01/2022 17:19:00","FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600,"FRAI__TTC":600}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"26/08/2021 14:11:00","FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4,"FRAI__TTC":19.4}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/03/2022 09:41:00","FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850,"FRAI__TTC":850}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"08/04/2022 09:40:00","FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15,"FRAI__TTC":478.15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"12/01/2022 16:06:00","FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715,"FRAI__TTC":715}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:33:00","FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:36:00","FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15,"FRAI__TTC":15}
{"SALA__NOM":"IRONE","SALA__PRENOM":"MAN","NDF__DATE_CREA":"11/02/2022 16:25:00","FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20}
{"SALA__NOM":"LESGATEAUX","SALA__PRENOM":"JAIME","NDF__DATE_CREA":"10/02/2022 19:10:00","FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/02/2022 16:52:00","FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20,"FRAI__TTC":20}
{"SALA__NOM":"BLACKET","SALA__PRENOM":"DECKER","NDF__DATE_CREA":"11/04/2022 17:40:00","FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450,"FRAI__TTC":450}
{"SALA__NOM":"DUJARDIN","SALA__PRENOM":"JEANETTE","NDF__DATE_CREA":"10/02/2022 19:08:00","FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203,"FRAI__TTC":203}
    voici le total des clé :
    SALA__NOM
SALA__PRENOM
SALA__MATRICULE
SALA__CODE_ANAL_1
SALA__POUR_ANAL_1
SALA__CODE_ANAL_2
SALA__POUR_ANAL_2
SALA__CODE_ANAL_3
SALA__POUR_ANAL_3
SALA__CODE_ANAL_4
SALA__POUR_ANAL_4
SALA__CODE_ANAL_5
SALA__POUR_ANAL_5
SALA__CODE_ANAL_6
SALA__POUR_ANAL_6
SALA__CODE_ANAL_7
SALA__POUR_ANAL_7
SALA__CODE_ANAL_8
SALA__POUR_ANAL_8
SALA__CODE_ANAL_9
SALA__POUR_ANAL_9
SALA__CODE_ANAL_10
SALA__POUR_ANAL_10
NDF__REFERENCE
NDF__DATE_CREA
NDF__PERI_CREA
NDF__DATE_BASC
NDF__PERI_BASC
NDF__CODE_NOTE
NDF__LIBE_NOTE
FRAI__DATE_DEPL
FRAI__CODE_FRAI
FRAI__LIBE_FRAI
FRAI__TTC
FRAI__HT
FRAI__TOTA_TVA
FRAI__TVA_20
FRAI__TVA_10
FRAI__TVA_55
FRAI__TVA_21
FRAI__TVA_GENE
FRAI__HT_DEDU
FRAI__TOTA_TVA_DEDU
FRAI__TVA_DEDU_20
FRAI__TVA_DEDU_10
FRAI__TVA_DEDU_55
FRAI__TVA_DEDU_21
FRAI__TVA_DEDU_GENE
FRAI__COMP_CHAR
FRAI__COMP_TVA_20
    Répondre avec citation Répondre avec citation   0  0
  6. 06/12/2023, 11h15 #6
    LandGreen
    LandGreen est déconnecté
    Membre très actif
    Homme Profil pro
    Développeur informatique
    Inscrit en
    Février 2018
    Messages
    454
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : Algérie

    Informations professionnelles :
    Activité : Développeur informatique
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Février 2018
    Messages : 454
    Par défaut
    Citation Envoyé par LandGreen Voir le message
    voici un exemple : ici on peut avoir plusieurs fois FRAI__TTC par exemple, mais il y a d'autres exemples ou j'ai d’autres Clé carrément inexistant ici

    voici le total des clé :
    SALA__NOM
SALA__PRENOM
SALA__MATRICULE
SALA__CODE_ANAL_1
SALA__POUR_ANAL_1
SALA__CODE_ANAL_2
SALA__POUR_ANAL_2
SALA__CODE_ANAL_3
SALA__POUR_ANAL_3
SALA__CODE_ANAL_4
SALA__POUR_ANAL_4
SALA__CODE_ANAL_5
SALA__POUR_ANAL_5
SALA__CODE_ANAL_6
SALA__POUR_ANAL_6
SALA__CODE_ANAL_7
SALA__POUR_ANAL_7
SALA__CODE_ANAL_8
SALA__POUR_ANAL_8
SALA__CODE_ANAL_9
SALA__POUR_ANAL_9
SALA__CODE_ANAL_10
SALA__POUR_ANAL_10
NDF__REFERENCE
NDF__DATE_CREA
NDF__PERI_CREA
NDF__DATE_BASC
NDF__PERI_BASC
NDF__CODE_NOTE
NDF__LIBE_NOTE
FRAI__DATE_DEPL
FRAI__CODE_FRAI
FRAI__LIBE_FRAI
FRAI__TTC
FRAI__HT
FRAI__TOTA_TVA
FRAI__TVA_20
FRAI__TVA_10
FRAI__TVA_55
FRAI__TVA_21
FRAI__TVA_GENE
FRAI__HT_DEDU
FRAI__TOTA_TVA_DEDU
FRAI__TVA_DEDU_20
FRAI__TVA_DEDU_10
FRAI__TVA_DEDU_55
FRAI__TVA_DEDU_21
FRAI__TVA_DEDU_GENE
FRAI__COMP_CHAR
FRAI__COMP_TVA_20
    le total des clés est stocké deans une colonne d'une autre table nommée TABLES_DES_CLES
    Répondre avec citation Répondre avec citation   0  0
+ Répondre à la discussion
Cette discussion est résolue.
ActualitésF.A.Q ORACLETUTORIELS ORACLETUTORIELS SQLSCRIPTS SQLLIVRES ORACLEQUIZ
« Discussion précédente | Discussion suivante »

Discussions similaires

  1. [Batch] Comment vérifier présence d'une certaine chaîne de caractère dans une variable ?
    Par Ekiam dans le forum Scripts/Batch
    Réponses: 3
    Dernier message: 24/03/2018, 23h51
  2. Somme des cellules d'une colonne telles que la cellule d'une autre ligne contienne une certaine chaîne
    Par laurentSc dans le forum Excel
    Réponses: 4
    Dernier message: 06/02/2015, 22h37
  3. insérer une ligne avant ou après un ligne contenant une certaine chaîne de caractères
    Par c1malabar dans le forum VBScript
    Réponses: 7
    Dernier message: 30/06/2011, 00h40
  4. Insérer une certaine chaîne de caractères dans MySQL
    Par laurentSc dans le forum Langage
    Réponses: 31
    Dernier message: 05/12/2009, 22h44
  5. Suppression des espaces consécutifs dans une chaîne de caractères
    Par amateurc dans le forum Pascal
    Réponses: 5
    Dernier message: 25/02/2008, 14h34

Partager

Partager
  • Envoyer la discussion sur Viadeo
  • Envoyer la discussion sur Twitter
  • Envoyer la discussion sur Google
  • Envoyer la discussion sur Facebook
  • Envoyer la discussion sur Digg
  • Envoyer la discussion sur Delicious
  • Envoyer la discussion sur MySpace
  • Envoyer la discussion sur Yahoo