Oracle

The Oracle garbled problem is generally caused by inconsistent Oracle character set settings and operating system character set settings, which have to mention two operating system environment variables, LANG and Nls_langLang is a set of languages,

Internal optimization issues for Oracle databasesThe internal optimization of Oracle database is a complex issue, and when you think of the internal understanding of Oracle, Oracle has removed some of the old features and added some new features.

Long time no Oracle, this time because of a project needs, and re-review of Oracle.The version of Oracle I am using is Windows Oracle 11G_R2.First, let's start with the installation. This is not a big problem, mainly in the installation time. There

Functions of the PL/SQL Foundation/* function: You can have a PL/SQL subroutine that returns a worthy name and must have a return value keyword:function return*/-- function 1Create or Replace function Helloworldreturn varchar2--specifies the return

1. Turn off Oracle server and background processes Ps-ef | grep Ora shut down the database shutdown immediate 2. Turn off the monitor lsnrctl status if it is on, do lsnrctl stop.3. Delete the $oracle_home file below and delete the database using the

Recently participated in 4, 5 interviews, summed up the competition in the Oracle development post most frequently asked what questions:1. What is the difference between delete and truncate?1) Truncate is a DDL statement, and delete is a DML

Just contact Oracle, in the learning process encountered a lot of problems, this article will collect my problems and how to solve.Error one: Ora-28009:connection as sys should be as SYSDBAWorkaround: User name: sys, password: password, host string:

If you accidentally overwrite the previous stored procedure, it's time to flash back, and the longer it is, the less likely it is to flash back. The principle is very simple, the definition of the stored procedure is a data dictionary, modify the

Because no relevant instructions were found on the official documentation, the following tests were performed to find the regularity of the retry time after the job failed in the Oracle database.Database version: 11.2.0.3Test Description: This

Hash join is a table JOIN method that uses HASH operations to obtain the JOIN result set when two tables are connected to tables. For sorting and merge joins, if the two tables obtain a large result set after applying the specified predicate

1. Materialized view is a special physical table. The Materialized view is relative to a general view. A common view is a virtual table, which has many application limitations. oracle converts any View query to a view SQL statement query. This

-- Create a table as a sub-tableCreate table fk_t as select * from user_objects;Delete from fk_t where object_id is null;Commit;-- Create a table as the parent tableCreate table pk_t as select * from user_objects;Delete from pk_t where object_id is

PL/SQL basic getting started code block PL/SQL:A programming Language combined with a Structured Language (Structured Query Language) is an extension of SQL and supports multiple data types, such as large objects and Collection types, you can use

Introduction: In MyBatis, when you want to insert data in Oracle, the primary key value is returned, instead of the number of inserted data... Environment: MyBatis 3.2, Oracle, Spring 3.2 SQL Snippet in XML Configuration: SELECT

ORA-19809: exceeds the limit on the number of recovery filesI. Fault symptom:RMAN> backup database;Start backup fromUse the target database control file to replace the recovery directoryAllocated channel: ORA_DISK_1Channel ORA_DISK_1: sid = 158

Basic PL/SQL Functions /* Function: You can have PL/SQL subprograms that are named, and must have returned values. Keyword: function return */ -- Function 1 Create or replace function helloworldreturn varchar2 -- specifies the return type. The

1. An error is reported when ORACLE software is installed to 86%. The figure is missing. The log is as follows: /Oracle/u01/app/oracle/product/11.2.0/INFO: db_1/lib/sysliblist '-R/opt/SUNWcluster/lib-R/export/home/oracle/u01/app/oracle/product/11.2.0

CASE Environment: Operating System: Oracle Linux Server release 5.7 64 bit Database Version: Oracle Database 10g Release 10.2.0.4.0-64bit Production Case study:On the server where the instance is just installed, when you use dbca to create a new

-- Create a table as a sub-table Create table fk_t as select * from user_objects; Delete from fk_t where object_id is null; Commit; -- Create a table as the parent table Create table pk_t as select * from user_objects; Delete from pk_t where

Stored procedures based on PL/SQL Stored Procedure: A process is a subroutine used to complete a specific task (a collection of code) /* Advantages of subprograms: 1. modular, decomposing programs into logic modules; 2. reusability, which can be