The difference between DB2 and Oracle
1, DB2 access to the first 10 lines of data and Oracle Difference
DB2:
SELECT * FROM Test fetch a
Oracle:
SELECT * FROM Test where rownumQuery statement
DB2: Do not provide stealth conversion
SELECT * from
DB2 TRUNCATE is used in DB2. There are two common methods to quickly clear data in a TABLE: alter table O_LNB_SM_USERINFO activate not logged initially with empty table; delete the table O_LNB_SM_USERINFO without logging the second import from
BKJIA exclusive Article: First of all, this article is not a detailed list of new features of DB2 9.7. I only list a list that is very important to DBAs or developers.
Online solution Modification
Please refer to Burt's article on online solution
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
We all know that the DB2 V9.7 database has introduced a series of new features. The emergence of these new features makes IT easier for customers to save IT costs. Specific features include compression enhancement, pureXML enhancement, usability
The following articles mainly introduce the comparison between common DB2 functions and Oracle functions. If you are curious about common DB2 functions and Oracle functions, this article will unveil the secrets of this article, the following is a
This article mainly describes the comparison between common DB2 functions and Oracle functions, including descriptions of type conversion functions, time and date, string functions, and mathematical functions, the following is a description of the
This article mainly describes the differences between the Oracle database and the DB2 stored procedure. If you are curious about the differences between the Oracle database and the DB2 stored procedure, you can click to view the following articles.
Oracle
How to present Oracle's relative functions in DB2 (II.)
Author:ccbzzp
In reality, you may often encounter some of the functions of Oracle in DB2,
Here I simply conclude that there may be many ways in which a function can be found, not all of
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.