Query problems for tables created by Oracle with NAVICAT

Navicat visual create a table, but just can't find! Why is this?

select * from user;

If we add double quotes to the user, we can find

SELECT * from "user";

Conclusion:

　　1. Oracle tables and fields are case-sensitive. Oracle defaults to uppercase, and if we enclose them in double quotes it is case-insensitive, and if not, the system will automatically turn into uppercase.

　　2, when we use Navicat to create a database using visual, Navicat automatically added "", when the database is created the actual code is this:

　　

DROP TABLE "ROOT". " User "; CREATE TABLE "ROOT". " User  number (2notNULL  )

　　3. I use SQL statements to create tables and fields

① do not add double quotes to create a variable capitalization

② with double quotes, as we do with the Navicat visualization

It is therefore recommended that:

1. It is also customary to develop handwritten SQL statements, and do not use double quotes when creating them! So that we can get to the same size as MySQL, etc. is not case-sensitive.

2. Try to capitalize on the habit of manipulating the database.

Query problems for tables created by Oracle with Navicat