The names of Oracle identifiers, such as tables and columns, must not exceed 30 characters in length. The first character must be a letter, but the rest can be any combination of letters, numerals, dollar signs ($), pound signs (#), and underscores (_).
However, if an Oracle identifier is enclosed by double quotation marks ("), then it can contain any combination of legal characters, including spaces but excluding quotation marks. Oracle identifiers are not case sensitive except within double quotation marks.
1.oracle的标识符(表名或列名)不应超过30字符。
2.oracle的标识符由字母、数字、$、#和下划线(_)组成,且开头必须由字母开头。
3.若oracle标识符被双引号("")引起来,则可以包括合法字符的任意组合,例如233table_column等。
4.oracle标识符不区分大小写,只有被双引号包围,才会区分大小写。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30167136/viewspace-1582597/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30167136/viewspace-1582597/