Author: (US) Tony Andrews Translator: Chen Yong Yang Health Series name: Chapter Hua programmer library Publishing House: Machinery Industry Publishing House ISBN: 9787111425021 shelving time: -6-4 published on: July 4,: 16 webpage: 86 versions: 1-1
This article from: http://www.bitscn.com/oracle/install/200604/16541.html
First, the following table describes the ing between Oracle and DB2/400 data types, which is a one-to-many relationship. The specific ing relationship should be analyzed
First of all, the corresponding relationship between the db2/400 data types is described in the following table, which is a one-to-many relationship, and the specific problem should be analyzed concretely.
Precautions:The date in Oracle contains
First, the table below describes the ing relationship with the DB2/400 data types, which is a one-to-many relationship. The specific ing relationship should be analyzed for specific issues.
Note:
The DATE in Oracle contains the year, month, day,
First, the following table describes the ing between Oracle and DB2/400 data types, which is a one-to-many relationship. The specific ing relationship should be analyzed according to specific issues.
Note:
Date and Time
The date in Oracle
Find an online comparison of Oracle and DB2 data types, and write them down.
Oracle
db2/400
Oracle data types
Precautions
DB2 UDB Data type
Precautions
DATE
DATETimeTIMESTAMP L
=========================oracle VS db2====================================This article transferred from: http://www.bitscn.com/oracle/install/200604/16541.htmlFirst, the following table describes the relationship between Oracle and db2/400 data
Different databases: oracle mysql SQL Server DB2 infomix sybase paging query statement, infomixsybase
Paging query statements used in different databases:
Current page: currentpagePage size: pagesize
1. Oracle Database
Select * from (select A. *,
The paging query method of DB2 is not the same as that of paging query statements in Oracle and SQL. The following describes the differences between paging query in DB2 and paging query in other databases.
Oracle paging query statement:
I.
Paged query statements that are used in different databases:Current page: CurrentPagePage Size: pagesize1. Oracle DatabaseSELECT * FROM (select A.*,rownum rn from (query_sql) A) where Rn (current Page*pagesize)Note: query_sql is a query SQL
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.