Oracle CREATE TABLE plus double quote function

Oracle -built table names and field names are automatically converted to uppercase.

Double quotation marks are case-sensitive in Oracle ,Oracle is case-sensitive, and all caps are default when double quotes are not used. Many people may mistakenly think that Oracle is case-insensitive, because when we write query statements, the case does not matter, the result is the same, it is only a superficial phenomenon, as long as you do not use double quotes to indicate case-sensitive,Oracle The script you write will be converted to uppercase by default.

CREATE TABLE "AUTHORISBN" (
"Authorid" INTEGER not NULL,
"TIT_ISBN" VARCHAR2 (20),
"Aut_authorid" INTEGER,
"ISBN" VARCHAR2 (20),
Constraint PK_AUTHORISBN primary KEY ("Authorid")
);

In Powerdesiger, in the physical data model, locate the edit current DBMS under database in the menu, select Script->sql->format, There is a casesensitivityusingquote, its comment is "determines if the case sensitivity for identifiers is managed using double quotes ", indicates whether double quotes are used to specify the case of identifiers, and you can see that the values on the right have the default value" YES "instead of" No "

http://blog.163.com/liuyang_yes/blog/static/128133212201182293538433/

Http://www.itpub.net/thread-1703955-1-1.html

Oracle CREATE TABLE plus double quote function