Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00911: invalid character

2676586Feb 10 2015 — edited Feb 10 2015

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2015
Added on Feb 10 2015
4 comments
2,645 views