set newp none pages 0 head on emb on
spool &1
select trim(DATE_ECRIT)
||';'||trim(CLOTURE_INSCRIPTION)
||';'||trim(LIMITE_SAISIE)
||';'||trim(CONSTITUTION_DOSSIER)
||';'||trim(ENVOI_DOSSIER)
||';'||trim(COM_MEDIATION)
||';'||trim(DEBUT_COM_EXAM)
||';'||trim(FIN_COM_EXAM)
||';'||trim(DECISION_MODALITE)
||';'||trim(JURY)
||';'||trim(ENVOI_CONVOCATION)
||';'||trim(DEBUT_ORAL)
||';'||trim(FIN_ORAL)
||';'||trim(FIN)
||';'||trim(NB_EPREUVES)
||';'||trim(VALIDITE_SESSION)
||';'||trim(SEUIL_PRE)
||';'||trim(SEUIL_ADMISSIBLITE)
||';'||trim(SEUIL_ADMISSION)
||';'||trim(COMMENTAIRE)
||';'||trim(EPREUVE_ECRITE)
||';'||trim(DATE_ARCHIVAGE)
||';'||trim(NB_PHASES)
||';'||trim(NUM_DECISION)
||';'||trim(TYPE_ADMISSION)
||';'||trim(FIN_DECISION_OUVERTURE)
||';'||trim(LIBELLE_SESSION) as "DATE_ECRIT;CLOTURE_INSCRIPTION;LIMITE_SAISIE;CONSTITUTION_DOSSIER;ENVOI_DOSSIER;COM_MEDIATION;DEBUT_COM_EXAM;FIN_COM_EXAM;DECISION_MODALITE;JURY;ENVOI_CONVOCATION;DEBUT_ORAL;FIN_ORAL;FIN;NB_EPREUVES;VALIDITE_SESSION;SEUIL_PRE;SEUIL_ADMISSIBLITE;SEUIL_ADMISSION;COMMENTAIRE;EPREUVE_ECRITE;DATE_ARCHIVAGE;NB_PHASES;NUM_DECISION;TYPE_ADMISSION;FIN_DECISION_OUVERTURE;LIBELLE_SESSION" from SESS;
spool off ;
Partager