ORA-00911: invalid character - Oracle Database 12c Error Messages

Channel:

java frm

Subscribers:

5,740

Published on March 10, 2023 7:30:26 PM ● Video Link: https://www.youtube.com/watch?v=qp-Ln05LMMw

Category:

Tutorial

Duration: 1:26

5 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message

ORA-00911: invalid character
Cause: The identifier name started with an ASCII character other than a letter or a
number. After the first character of the identifier name, ASCII characters are allowed
including "$", "#" and "_". Identifiers enclosed in double quotation marks may contain
any character other than a double quotation. Alternate quotation marks (q'#...#')
cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts,
consult the SQL Language Reference Manual.
Action: Check the Oracle identifier naming convention. If you are attempting to
provide a password in the IDENTIFIED BY clause of a CREATE USER or ALTER
USER statement, then it is recommended to always enclose the password in double
quotation marks because characters other than the double quotation are then
allowed.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database