oracle 識別符號規範

winston_DBA發表於2015-04-17
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章