I use Schema browser. On one table, Data Grid, Make filter on column DT_EMIS, (Custom filter...)
“Is greate than”, only one char possible !
With column DT_CREATE (type DATE) the filter is possible.
The table :
CREATE TABLE OPS$APCEXP.SYN_PUB_TRAIN
(
ID_PUB_TRAIN NUMBER NOT NULL,
ID_REV NUMBER NOT NULL,
GRP_PUB VARCHAR2(255 CHAR) NOT NULL,
ETAT_PUB VARCHAR2(30 CHAR) NOT NULL,
DT_EMIS TIMESTAMP(6) NOT NULL,
DT_PUB TIMESTAMP(6),
DESC_PUB VARCHAR2(4000 CHAR),
DONNEES_PUB CLOB NOT NULL,
NO_VERS NUMBER DEFAULT 1 NOT NULL,
DT_CREAT DATE DEFAULT SYSDATE,
CD_UTILIS_CREAT VARCHAR2(30 CHAR) DEFAULT SYS_CONTEXT('USERENV','OS_USER'),
DT_MAJ DATE DEFAULT SYSDATE,
CD_UTILIS_MAJ VARCHAR2(30 CHAR) DEFAULT SYS_CONTEXT('USERENV','OS_USER'),
COMMENT_ABANDON VARCHAR2(255 CHAR),
CD_UTILIS_ABANDON VARCHAR2(30 CHAR),
DT_ABANDON DATE
)
LOB (DONNEES_PUB) STORE AS BASICFILE (TABLESPACE REF_FBA_DAT)
TABLESPACE REF_FBA_DAT;