Dear All,
While i am running the below sql, i am facing:
Can anyone suggest where I am going wrong?
ORA-00911: invalid character
00911. 00000 - "invalid character"
*Cause: identifiers may not start with any ASCII character other than
letters and numbers. $#_ are also allowed after the first
character. Identifiers enclosed by doublequotes may contain
any character other than a doublequote. Alternative quotes
(q'#...#') cannot use spaces, tabs, or carriage returns as
delimiters. For all other contexts, consult the SQL Language
Reference Manual.
*Action:
Error at Line: 6 Column: 89
/* Formatted on 2/10/2015 12:26:28 PM (QP5 v5.227.12220.39724) */
SELECT MIN (creation_time)
FROM table_name
WHERE TO_DATE ( (SUBSTR (time_stamp, 0, 10)), 'YYYY/MM/DD') BETWEEN TO_DATE (
'2015-01-01',
'YYYY-MM-DD') AND TO_DATE('2015-02-01', 'YYYY-MM-DD')
and event_id LIKE '%filename%.xml'
GROUP BY creation_time;
time_stamp is varchar.