Oracle

Dbms_output packages are primarily used to debug pl/sql programs, or to display information (displaying messages) and reports in Sql*plus commands, such as we can write a simple anonymous PL/SQL program block that is used for some reason Dbms_

To report the system environment in the usual way: Export environment: Operating system Release version :CentOS 6.5 OS kernel kernel version: 2.6.32-431.el6.x86.64 Oracle Version information: Sql> select * from V$version; BANNER----------------------

The first is to create a table with subtle differences, to determine whether a table exists, accustomed to MS SQL OBJECT_ID (' Object table ', ' object type ') of children's shoes, you are not thinking of Oracle should have such a function.

in Unix The system handles bare devices above:   1. What is called a bare device.A bare device, also called a bare partition (raw partition), is a special character device that is not formatted and is not read by UNIX through a file system. It is

Navicat version: Navicat Premium 9.1.11 Oracle version: Oracle Database 10g Release 2 (10.2.0.1.0) The following figure, failed to connect to the Oracle database using Navicat Problem Reason:Navicat OCI.dll does not support the GBK character

Oracle Dataguard Build Manual First, preparatory work1, the installation of database software:Primary and Standby Install database software:Step 7: Select the recovery area for the database: Tick Specify the Quick Resume option and enable archiving.

1. Install Oracle only, do not create DATABASE, if you have already created a database, 2, the simple point is to change the original database Oracle directory to oracle_bak, reinstall the database Back up the Oracle\product\10.1.10\oradata database

1 Goals Demonstrates how to create, delete, disable, and use a uniqueness constraint with an example. 2 What is a uniqueness constraint. A uniqueness constraint refers to a constraint in a table in which a field or multiple fields combine to

When you modify a field type for a table that already has data, Oracle prompts: ORA-01439: To change the data type, the column to be modified must be empty.   You can create a new table, fill in the original table data, and then rename it, or create

Backup type: A full backup contains all the used data file blocks. A level 0 incremental backup is equivalent to a full backup marked Level 0. The cumulative Level 1 incremental backup contains only the blocks that have been modified since the

Introduction: The source of this article is because one of my students recently set up a RAC cluster in the company, but the sequence and principle of its startup and shutdown are not particularly clear, and I have found many students who know very

Reproduced from: http://blog.csdn.net/hijiankang/article/details/9173877/ I. Theoretical knowledge of partitioned tables Oracle provides partitioning technology to support VLDB (Very Large DataBase). The partitioned table puts different records of

Hint is the embodiment of Oracle database flexibility. Because hint has the highest priority, it is possible to hint the optimizer to generate a specified execution plan based on the needs of the user. Oracle has a wide variety of hint, roughly

Spent two or three days to configure Oracle Enterprise Manager, referred to as EM, whether through the DBCA or EMCA commands are always failure, in the search for a lot of information without fruit, after a toss finally configured successfully, and

The role of foreign keys: maintain data consistency and integrity, primarily to control the storage of data in foreign key tables. causes the two tables to be associated, and the foreign key can only refer to the values of the columns in the outer

Immediately thereafter: http://ixdba.blog.51cto.com/2895551/882362 After the Oracle Clusterware installation is successful, start the installation of Oracle database, log on to any cluster node as an Oracle user, and start the installation by

Difference: 1. The length of the char is fixed, the length of the VARCHAR2 can vary, for example, the storage string "abc", for Char (20), which means that the characters you store will occupy 20 bytes (including 17 null characters), while the same

The company installs an Oracle 12c test environment, is ready to export the online library to test performance, the results of the test library of the character set selected Al32utf8, a look at the line is ZHS16GBK, or to maintain the same, and then

*********************************************** Statement ********************************************** Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise the legal liability for

--=========== 0:xserver PreparationInstall Xserver, configure Xshell--xming,xmanager,vcxsrv--=========== 1: Disk Partitioning and mountingcd/etc/yum.repos.d/# # SCP Ol6.repo root:10.198.15.105:/etc/yum.repos.d/RM