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_

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

To study Oracle databases, it is too cumbersome to install Oracle, so think about saving things and use Oracle in Docker as an exercise. Search Oracle Database mirroring files using the sudo docker search Oracle command, where a related mirror has

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

Show all employee names in lowercase to show the names of all employees in uppercase format. Displays the name of the employee who is exactly 5 characters. Displays the first three characters of all employee names. Displays the names of all

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

Table size with two meanings in OracleOne is the amount of physical space allocated to a table, regardless of whether space is used or not. You can get the number of bytes in this query:Select Segment_name, bytesFrom User_segmentswhere segment_type =

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

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

Experimental environment: SOURCE End: ip:192.168.40.10 Database:oracle 11.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit Target side: ip:192.168.40.128 database:10.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit First configure

To introduce the character function first:Case Related:1. Select lower (' Hellow '), Upper (' Hehhlo '), Initcap (' Oello ') from dual;--dual empty table. Results: Hellow Hehhlo Oello and Case Independent:1. SELECT trim (' h ' from ' hellowhh '),

Sequence: A database object provided by Oacle to produce a series of unique digits. L provide a unique numeric value automatically L Shared objects L primarily used to provide primary key values L Loading sequence values into memory can improve

Download the appropriate version via Oracle's official website: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html MVN install:install-file-dgroupid=com.oracle-dartifactid=ojdbc14-dversion=10.2.0.1.0-dpackaging=jar-dfile=

Create directory gives us the flexibility to read and write files in an Oracle database, greatly improving the ease of use and scalability of Oracle. The syntax is: CREATE [OR REPLACE] Directory directory as ' pathname '; This case is specifically

Function: The application of the corresponding SQL statements, can be convenient and quick query Oracle database specified users of all user table description, quickly know what each data table is to do, easy to write documents and