Today, the customer visited (Japanese) and asked me the difference between DB2 and Oracle. Because it's not a DBA, I haven't really summed it up. But my first feeling: One is instance, one is database. Building Ora libraries and DB2 libraries is not
1. Combined statement execution
Begin atomic
Expression 1, semicolon, space, and carriage return
Expression 2; semicolon (,), space, and carriage return
End
2. Tables with limited access permissions (the Public select access permission for
TurnRecently in see DB2, read while writing some, write down, although write a mess. For later use.These are all very simple to write. I think it is some simple operation, and some are excerpted from other people's blog specific is to cite which is
The db2 tutorial is: Daily maintenance Summary of IBM DB2 (6 ). 91. How to Create a summary table of DB2?
The overview table function of DB2 is similar to the materialized view of ORACLE!
Syntax:
CREATESUMMARYTABLETABLE_NAMEAS (FULLSELECT )...
For
The db2 tutorial is: Daily maintenance Summary of IBM DB2 (6 ). 91. How to Create a summary table of DB2?The overview table function of DB2 is similar to the materialized view of ORACLE!Syntax:CREATESUMMARYTABLETABLE_NAMEAS (FULLSELECT )...For
The DB2 tutorial you are looking at is: IBM DB2 Daily Maintenance Summary (vi). 91. How do I create a DB2 summary table?
DB2 's summary table functionality is similar to the materialized view of Oracle!
The syntax is:
Createsummarytabletable_nameas (
In general, it is impossible to avoid any problems during the migration of DB2 database applications. This article will introduce some problems that may occur during the migration of DB2 database applications. BKJIA has previously introduced how to
Http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0604changhp/
The powerful functions provided by DB2 allow developers to create highly efficient and stable stored procedures. But for beginnersProgramIt is not easy. This article
The main differences between DB2 and ORACLE SQL notation
To be honest, Oracle has spoiled the country's programmers, and SQL in the code is flooded with Oracle features, and almost no one knows what ANSI's standard SQL looks like,
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.