Common oracle database management system errors (2 ),

Common oracle database management system errors (2 ),

Oracle databases always encounter the following problems for new users:

I believe everyone has encountered such a problem. To be honest, I have encountered such a problem before, but I am sorry to ask the technical experts next to me, and I am a little skeptical about my life, then, I searched for the cause on the Internet and found that various online versions,

It's hard to find the cause. Not long ago, some people asked me this question, so I solved it for the same person who made this mistake:

In fact, the reason for this problem is that the default table name and field name of Oracle are in upper case, so Oracle will automatically convert to upper case when lower case is used. To add a lower-case table name, you must add quotation marks ("") when creating the table name ("")

Therefore, you only need to add quotation marks to the table name.

In this way, you can find out.

Of course, if navicat is used to create a database visually, navicat automatically adds "" to us. In this way, when creating a database, the actual code should be "root". XXX "before the table name.

Create table Name message, which can be written as create table "root". message (...); in this way, you can create a lower-case table name. However, this method is not recommended because the default table name and

The field names are capitalized, so we need to develop a good habit of using uppercase when writing SQL, to prevent unnecessary troubles. In later learning, using the table name with quotation marks will also cause

Some of the troubles.

 

I don't know how everyone is doing. If there is a problem, you can leave a message below and I will answer it for you.