Symfony Profiler

SELECT
  *
FROM
  V_INFOS_CARTE
where
  IDE_DOSSIER = 4200

SELECT * FROM V_INFOS_CARTE where IDE_DOSSIER=4200;

SELECT
  *
FROM
  V_DATA_VCARD
where
  IDE_DOSSIER = 4200

SELECT * FROM V_DATA_VCARD where IDE_DOSSIER=4200;

SELECT
  *
FROM
  V_PERSONNEL
where
  LOWER(EMAIL_PRO)= 'stephane.girardon@ensam.eu'

SELECT * FROM V_PERSONNEL where LOWER(EMAIL_PRO)='stephane.girardon@ensam.eu';

SELECT
  *
FROM
  V_PERSONNEL
where
  IDE_DOSSIER = 4200

SELECT * FROM V_PERSONNEL where IDE_DOSSIER=4200;

select
  *
from
  VCARD
where
  IDE_DOSSIER = '4200'
  and (STATUT = 'validé')
order by
  D_MODIFICATION desc

select * from VCARD where IDE_DOSSIER='4200' and ( STATUT = 'validé' )  order by  D_MODIFICATION desc ;

select
  *
from
  VCARD
where
  IDE_DOSSIER = '4200'
  and (
    STATUT = 'enregistrée'
    OR STATUT = 'à valider'
  )
order by
  D_MODIFICATION desc

select * from VCARD where IDE_DOSSIER='4200' and ( STATUT = 'enregistrée' OR STATUT='à valider' )  order by  D_MODIFICATION desc ;

ALTER SESSION
SET
  NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,';