Four simple guidelines to improve the number and quality of Pl/sql code
I've been writing Pl/sql code since 1990. That means I've written tens of thousands of of lines of software code, but I'm sure most of the code is very clumsy and difficult to
Data pump enables fast data migration between test environments, development environments, production environments, and advanced replication or hot backup databases. Data pump can also implement some or all of the database logical backups, as well
Because of the reasons for the project need to use the Oracle database, due to time constraints can not learn from the foundation, and the Oracle operation of the command interface is too unfriendly, so I found Pl/sql developer this very useful
1. Brief Introduction:
Oracle's Sql*plus is a client tool that interacts with Oracle. In Sqlplus, you can run the Sqlplus command and the Sqlplus statement, and the DML, DDL, and DCL statements that we normally refer to are sqlplus statements that,
First, simple query
SQL (structured query Language) Structured Query language is a database query and programming language for accessing data and querying, updating, and managing relational database systems. ANSI (American National Standards
This article from the following aspects to collate the concept and operation of the partition table:1. Table space and the concept of partitioned tables2. The specific role of table partitioning3. Advantages and disadvantages of table partitioning4.
Previously, the LOB fields were processed using the Dbms_lob package, and a recent document found that many of the commonly used character functions support lob fields.
Create a test table:
Sql> CREATE TABLE T_lob (ID number, CONTENTS CLOB);
Oracle Text is a powerful search technology that is built into all versions of the Oracle database, including free available version (XE). It provides a development API that makes it easy for software developers to implement full-featured content
Relative to physical standby, the management of logical standby is a little more complicated. This is the difference between managing a half database and managing two of databases (assuming that the data guard environment is a master standby
Some time ago in a migration of data pump and exp, found that the difference in efficiency is quite large. Here is an example of a simple comparison.
This article compares the differences between IMP and IMPDP import.
The comparison of exp and
Oracle OCP Notes (31) using the Flashback featureOracle's flashback feature is supported by one of 3 database architectures: Undo data, Flashback recovery area, and Recycle Bin.Undoing data in the undo Tablespace not only supports transaction
A trigger (trigger) is a special stored procedure whose execution is not invoked by the program or manually, but is triggered by an event, such as when an operation on a table (Insert,delete, update) activates it for execution. Triggers are often
1.charThe length of char is fixed, for example, you define char (20), even if you insert ABC, less than 20 bytes, the database will automatically add 17 spaces after ABC to complement 20 bytes;Char is a distinction between English and Chinese, which
"[INS-30131] the Initial Setup that's Required to Run the installation program Validation were not successful" Error Wh Ile installing Oracle Database (Doc ID 1569962.1)
To Bottom
In this Document
All along, the use of big data is far less than the big data collection ability, the main reason is that the current enterprise data is mainly scattered in different systems or organizations, big Data strategy is to be able to more depth, more
Heterogeneous data sources interact with Oracle database. Figure 1 is an Oracle heterogeneous Connection processing architecture diagram where we can see that the main non-data source modules include the HS (heterogeneous Service), Agent. There is
Experience in SQL statement optimization and SQL statement Optimization
(1) select the most efficient table name sequence (only valid in the rule-based seo/'target = '_ blank'> Optimizer ): the ORACLE parser processes the table names in the FROM
Oracle team helps to integrate enterprise systems and improve database performance
Wu Chengyang, vice president of Oracle and General Manager of the Greater China technology product department, stressed that the integration of information systems
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service