Default Data Type Mappings Used by Oracle SQL Developer
[@more@]
Table 2-4 Default Data Type Mappings Used by Oracle SQL Developer
| MySQL Data Type | Oracle Data Type |
|---|---|
BIGINT | NUMBER(19, 0) |
BIT | RAW |
BLOB | BLOB, RAW |
CHAR | CHAR |
DATE | DATE |
DATETIME | DATE |
DECIMAL | FLOAT (24) |
DOUBLE | FLOAT (24) |
DOUBLE PRECISION | FLOAT (24) |
ENUM | VARCHAR2 |
FLOAT | FLOAT |
INT | NUMBER(10, 0) |
INTEGER | NUMBER(10, 0) |
LONGBLOB | BLOB, RAW |
LONGTEXT | CLOB, RAW |
MEDIUMBLOB | BLOB, RAW |
MEDIUMINT | NUMBER(7, 0) |
MEDIUMTEXT | CLOB, RAW |
NUMERIC | NUMBER |
REAL | FLOAT (24) |
SET | VARCHAR2 |
SMALLINT | NUMBER(5, 0) |
TEXT | VARCHAR2, CLOB |
TIME | DATE |
TIMESTAMP | DATE |
TINYBLOB | RAW |
TINYINT | NUMBER(3, 0) |
TINYTEXT | VARCHAR2 |
VARCHAR | VARCHAR2, CLOB |
YEAR | NUMBER |
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7591490/viewspace-1026395/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Specifying the Default Tablespace Type (78)
- PL/SQL Developer 連線 OracleSQLDeveloperOracle
- Oracle SQL Developer安裝教程OracleSQLDeveloper
- ORACLE SQL DEVELOPER User Interface ChangeOracleSQLDeveloper
- oracle sql developer 2.1如何連線oracleOracleSQLDeveloper
- Overriding the Default Tablespace Type (79)
- ORACLE SQL Developer 64 bit DownloadOracleSQLDeveloper
- 【Oracle】Windows安裝pl/sql developerOracleWindowsSQLDeveloper
- Oracle GoldenGate – MappingsOracleGoAPP
- Oracle SQL Developer New Features in Release 4OracleSQLDeveloper
- 使用Oracle SQL Developer匯入Excel資料OracleSQLDeveloperExcel
- Oracle SQL Developer Debug儲存過程OracleSQLDeveloper儲存過程
- Oracle SQL Developer 4.1 和 SQLcl 的新特性OracleSQLDeveloper
- oracle自帶的sql developer使用問題OracleSQLDeveloper
- 解決 TypeError: Type aliases cannot be used with isinstance(). 辦法Error
- Choosing Column Data Type
- 在toad_plsql developer_oracle sql developer呼叫儲存過程SQLDeveloperOracle儲存過程
- Oracle default usersOracle
- 「Oracle」客戶端 PL/SQL DEVELOPER 安裝使用Oracle客戶端SQLDeveloper
- PL/SQL Developer連線到Oracle 12cSQLDeveloperOracle
- Oracle instant client及pl sql developer的使用OracleclientSQLDeveloper
- PL/SQl Developer使用SQLDeveloper
- PL/SQL Developer 使用SQLDeveloper
- 【Oracle】常用工具-oracle sql developer快速安裝使用教程OracleSQLDeveloper
- Material type ROH cannot be used with item category L (plant T001)Go
- PL/SQL Developer連線遠端Oracle資料庫SQLDeveloperOracle資料庫
- ORACLE SQL Developer4資料庫複製案例OracleSQLDeveloper資料庫
- note of Beginning Oracle SQL-Oracle Data Dictionary ViewsOracleSQLView
- 聊聊Oracle Default RoleOracle
- Oracle Least Recently Used ChainsOracleASTAI
- Oracle ASM Disk Used Space DirectoryOracleASM
- 異構資料庫系統遷移到Oracle 工具 - Oracle SQL Developer資料庫OracleSQLDeveloper
- Oracle 11g的SQL Developer連線SQL Server 2008OracleSQLDeveloperServer
- oracle資料型別data type與儲存空間大小（一）Oracle資料型別
- oracle資料型別data type與儲存空間大小（二）Oracle資料型別
- pl/sql developer使用技巧SQLDeveloper
- 5. Oracle連線和使用——5.2. PL/SQL DeveloperOracleSQLDeveloper
- Oracle管理監控之sql developer配置與簡單使用OracleSQLDeveloper