by tkprof I use explain plan option and I have error ORA-00904: "TESTDATE": invalid identifier erro
I would like control several queries then I have a problem with explain plan with tkprof.
regards
Jean-Pierre
INSERT INTO diy00SUI.FMK_DATA_TRACE (NUMLOT,GROUPE,CODE_EVT,TN_IDTSEQ,COLONNE,
VALEUR,TYPE_ERR) SELECT NUMLOT,'P0151F' as Groupe,'P0151F' as Code_evt,
TN_IDTSEQ,'DD_CRE'as Colonne, DD_CRE as Valeur , 'CheckDate' as TYPE_ERR
from diy00PRI.T_TCLOD_P0151F#10 WHERE TESTDATE(DD_CRE,'N','YYYY-MM-DD') =
1 AND trim(DD_CRE) <> '/NULL' AND trim(DD_CRE) <> '*N/D*'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------