Oracle Access Database Field and Table Name CAUTION Are Case Area?

xiaoxiao2021-04-05  251

It is distinguished

It has always been used in the library. As a result, I forgot this attribute when I use PD9. I have to name "Table Space" in front of the database. "Table name" Must be added, you must record the case, otherwise tell me that there is no view, depressed to death, I checked the relevant pages, the answer is distinguished, but it is necessary to force the distinction between the table, it is said to use the table Double quotes.

Otherwise, Oracle does not distinguish between the default, you can use your lowercase, it doesn't matter, oracle automatically converts to uppercase, and you can use case when calling. If you enforce your case if you build a table, you will use the Upper, Lower function to transform.

As for the data stored in the table, there is still a distinction, and the capital uppercase is uppercase, and the lowercase is lower-written, pay attention to when queries. Remember the next time you handle, pitiful, you have to remove the "Remove Quotes" on a hundreds of tables, you have to remove the quotation marks on the database table name in the way! The name of this Name2 doesn't have to add namespace :))

转载请注明原文地址:https://www.9cbs.com/read-132144.html

New Post(0)