Sometimes it is requied to support sqlserver & oracle databaes for application. Both database came from different vendors. when you want to compatable both database then some issue you have to solve.
1. First Issue Datatype
SQL Server Oracle
------------------------------------------------------------------------------------------
1. TINYINT NUMBER(3)
2. SMALLINT NUMBER(6)
3. INT NUMBER(10)
4. BIGINT NUMBER(19)
5. BIT NUMBER(1)
6. VARCHAR VARCHAR2
7. SAMLLDATETIME/DATETIME DATE/TIMESTAMP
8. TIMESTAMP TIMESTAMP
9. MONEY NUMBER(19,4)
10. TEXT CLOB
11. BINARY/IMAGE BLOB
12. SQL_VARIANT SYS_ANYDATA
13. TABLE VARRAYS/NESTEDTABLE
14. UNIQUEIDENTIFIED VARCHAR2(50)
No comments:
Post a Comment