Oracle Data Types
Data Type | Description |
VARCHAR2(size) | Variable-length character data |
CHAR(size) | Fixed-length character data |
NUMBER(p,s) | Variable-length numeric data |
DATE | Date and time values |
LONG | Variable-length character data(up to 2G);Oracle推荐不使用此数据类型,推荐使用CLOB、BLOB |
CLOB | Character data(up to 4GB) |
RAW and LONG RAW | Raw binary data |
BLOB | Binary data(up to 4GB) |
BFILE | Binary data stored in an external file(up to 4GB) |
ROWID | A base-64 number system representing the unique address of a row in its table. |
Data Type | Description |
TIMESTAMP | Date with fractional seconds |
INTERVAL YEAR TO MONTH | Stored as an interval of years and moths |
INTERVAL DAY TO SECOND | Stored as an interval days,hours,mintues,and seconds |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步