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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 使用Oracle SQL Developer匯入Excel資料OracleSQLDeveloperExcel
- 「Oracle」客戶端 PL/SQL DEVELOPER 安裝使用Oracle客戶端SQLDeveloper
- PL/SQL Developer連線到Oracle 12cSQLDeveloperOracle
- 【Oracle】常用工具-oracle sql developer快速安裝使用教程OracleSQLDeveloper
- Oracle Least Recently Used ChainsOracleASTAI
- PL/SQL Developer連線遠端Oracle資料庫SQLDeveloperOracle資料庫
- Oracle default usersOracle
- HITSC_4_Data Type and Type Checking
- 解決 TypeError: Type aliases cannot be used with isinstance(). 辦法Error
- 5. Oracle連線和使用——5.2. PL/SQL DeveloperOracleSQLDeveloper
- 本地不安裝oracle，用PL/SQL Developer連線資料庫OracleSQLDeveloper資料庫
- oracle enqueue typeOracleENQ
- 18 與Oracle Data Guard 相關的SQL語句OracleSQL
- Oracle SQL Developer 連線資料庫總是顯示io錯誤OracleSQLDeveloper資料庫
- oracle: default role 詳解(轉)Oracle
- #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs
- HITSC_6_Abstract Data Type (ADT)
- plsql developer工具生成sql monitor reportSQLDeveloper
- 09 對映（mappings）APP
- Rust的變數型別__Data typeRust變數型別
- [20220708]PLSQL – choosing the BEST data type.txtSQL
- Oracle data link建立Oracle
- pl/sql developer的一個小問題SQLDeveloper
- [Vue warn]: The data property "dialogVisible" is already declared as a prop. Use prop default valueVue
- 4.1.6 Oracle Restart 與 Oracle Data Guard 整合OracleREST
- Oracle Data Guard Broker元件Oracle元件
- Oracle Data Guard簡介Oracle
- Developer 帶有名為 SQL Server Compact 免費的 SQL 資料庫DeveloperSQLServer資料庫
- ORACLE中%TYPE和%ROWTYPE的使用Oracle
- C# convert sql blob type to plain stringC#SQLAI
- PL/SQL Developer下載地址和漢化包地址SQLDeveloper
- Oracle Data Guard和Broker概述Oracle
- 1 關於 Oracle Data GuardOracle
- 2 Oracle Data Guard 安裝Oracle
- 1 Oracle Data Guard Broker 概念Oracle
- [專案踩坑] py executemany 的使用報錯：Not all parameters were used in the SQLSQL
- Oracle PL/SQLOracleSQL
- 【ASK_ORACLE】Oracle Data Guard（一）DG架構Oracle架構
- Oracle資料泵(Oracle Data Pump) 19cOracle