Pl/sql coding rules to be followed by Oracle databases

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

Oracle Learning (21) Importing and exporting using data pump bump

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

Oracle Database Dataguard 11GR2 RAC to RAC configuration

Data Schema Primary: The code is as follows Copy Code hostname    databasename    unique_dbname   INSTANCE_NAME RAC1                  orclpd                            orclpd                              ORCLPD1 rac2  

Diagram of ways to connect Oracle databases using PL/SQL developer _oracle

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

Oracle Sqlplus Command Encyclopedia _oracle

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,

Oracle simple query, qualified query, data sort SQL statement examples and detailed annotations _oracle

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

An explanation of Oracle table Space table partitioning and application method of Oracle table partitioning query _oracle

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.

The commonly-in-character function of LOB fields in Oracle

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);

Building a Full-text Search application with Oracle text

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

Oracle DG modifies logical standby-side data

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

Oracle 10g Data pump and import Export performance comparison (ii) the difference between IMP and IMPDP import

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 feature

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

The specific definition of Oracle triggers, when to use! The advantage is what!

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

The difference between varchar, VARCHAR2, char, and nvarchar in Oracle

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

Windows install Oracle 12c error:[INS-30131]

"[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

New technologies bridge the gap between Oracle, Hadoop, and NoSQL data stores

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

"Book Review: Oracle Query Optimization Rewrite" chapter fourth

"Book Review: Oracle Query Optimization Rewrite" chapter fourth Blog Document structure diagram 650) this.width=650; "title=" wpse60b.tmp "border=" 0 "alt=" wpse60b.tmp "src=" http://s3.51cto.com/wyfs02/M00/6D/0B/ Wkiom1varbyhcepqaabjdaqoiyu258.jpg "

Oracle HS (heterogeneous Services) in-depth analysis and collaborative Gateway Workflow (RPM)

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

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

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

Total Pages: 2147 1 .... 126 127 128 129 130 .... 2147 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.