Database Tuning (MOSC)

MOSC Banner

by tkprof I use explain plan option and I have error ORA-00904: "TESTDATE": invalid identifier erro

edited Nov 28, 2011 7:07PM in Database Tuning (MOSC) 5 comments
Hello Gurus,

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
------- ------  -------- ---------- ---------- ---------- ----------  ----------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center