ORA-00911: invalid character

I got ” ORA-00911: invalid character” error in Oracle database.

 

ORA-00911: invalid character

 

Details of error are as follows.

ORA-00911: 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: None

 

 

invalid character

This ORA-00911 errors are related with the 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.

Generally the semicolon (;), backtick (“) etc. from inside a query caused this error, you need to remove this from a query.

 

If you use a special character is added in an SQL statement with column name, you will get this error.

 when a special character is added in an SQL statement with column name
SQL> select name# from hr.employee;
select name# from hr.employee
*
ERROR at line 1:
ORA-00904: "name#": invalid identifier

 

Or If you use Acute` instead of quote’, you will get this error.

SQL> select * from hr.employee where name like `N%`;
select * from hr.employee where name like `N%`
*
ERROR at line 1:
ORA-00911: invalid character

Don’t forget to enclose by single quotes in where clause condition as follows.

SQL> select * from emp where name like A%;
select * from emp where name like A%
*
ERROR at line 1:
ORA-00911: invalid character

 

Or don’t use extra semicolon (;) at the end of the query.

SQL> select empno from emp;;
select empno from emp;
*
ERROR at line 1:
ORA-00911: invalid character

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

 470 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply