Oracle

When creating an oracle index, you can add nosegment to the SQL statement to quickly create a virtual index. For example, create index index_name on table_name (col_name) nosegment; if you need to test the virtual index in which session, you can use

Oracle re-creates the Stored Procedure (re-indexing) for all table indexes SQL code/* function: re-creates the index. Note: If the tablespace parameter is null, the index is re-created in the original tablespace; otherwise, the index is re-created

Oracle stored procedure: cursor and dynamic SQL 1. create package + CURSOR SQL code CREATE OR REPLACE PACKAGE RefCursor IS type t_RefCursor IS ref CURSOR; END RefCursor; 2. create a stored procedure and define the in and out parameters. SQL code

Structured Query Language (Structured Query Language), also known as Structured Query Language, is a standard Language for defining and querying and manipulating data in relational databases, it is an interface for communication between users and

Oracle statistics function learning database preparation Java code create table emp (deptno int not null, ename varchar (100) default null, sal int default null); insert into emp values (10, 'King', 5000); insert into emp values (10, 'clark', 2450);

In-depth understanding of Oracle partitions (1): How to implement and evaluate partitionsAlthough this blog post aims to guide everyone in how to create partitions in the production environmentBut never be bound by some so-called Design Guides,

String separated by commas (,) to create or replace function "GET_STR_TAB" (v_str in varchar2) return table_str pipelined as v_new_str varchar2 (8000 ); begin if v_str is null then pipe row (-1); else v_new_str: = replace (v_str, chr (10), ''), chr (

"No pre-requisite checks found in oraparam. ini, no system pre-requisite checks will be executed." solution [oracle @ orcl ~] $. /RunInstaller "No pre-requisite checks found in oraparam. ini, no system pre-requisite checks will be executed. "This

CREATE an oracle exercise TABLE SQL code CREATE TABLE DEPT (DEPTNO NUMBER (2) CONSTRAINT PK_DEPT PRIMARY KEY, DNAME VARCHAR2 (14), LOC VARCHAR2 (13 )); create table emp (empno number (4) CONSTRAINT PK_EMP primary key, ENAME VARCHAR2 (10), JOB

Oracle trigger practice (ADD, modify, delete) to monitor the addition, modification, and deletion of a table, and record it to another table... the specific code is as follows: SQL code create or replace trigger test_trigger before insert or update

Connect to the same database instance with the same SID. The two instances are on different servers, such as my tnsnames file # tnsnames. ora Network Configuration File: D: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ tnsnames. ora #

Oracle Stored PROCEDURE read file create or replace PROCEDURE PR_FINANCE_PRODUCT_PARSE (v_filename IN VARCHAR2, -- Resolution file name v_retvalue out number -- 1 is successful, 0 is failed) AS -- file handle filehandle utl_file.file_type; -- buffer

The Oracle-ddl command alter table is a ddl operation. Ddl operation implies commit-if you do not understand this, you may find another similar alter index in the next time... Again. -- Disable all trriger alter table table_name disable all triggers;

Difference between count (*) and count (col) in the query 1. create the test table declare l_ SQL varchar2 (32767); begin l_ SQL: = 'create table t ('; for I in 1 .. 999 loop l_ SQL: = l_ SQL | 'n' | I | 'number, '; end loop; l_ SQL: = l_ SQL | 'pad

Introduction to the three major oracle partitions: the range, hash, and list partitions of oracle may not be familiar to all of us. However, many people may wonder what scenarios each partition applies, so what should we pay attention to when

Oracle user-maneged recovery (2) Restoration Process for restoring data files to a new location: 1. use the operating system command to COPY the file to the new location 2. start and load the database 3. use the alter database command to update the

[Oracle] Three table connection algorithms summary Oracle has three table connection technologies: Nested connection, merge connection, and hash connection. 1. nested loop Join divides the dataset to be processed into an External LOOP (driving data

In the Oracle Crash case, I received a call report saying that an Oracle database was inexplicably crash when I got off work. Let me go to the site to see it. At the scene, the on-site maintenance personnel said that the database was automatically

[Oracle problem set 1] ORA-00845: MEMORY_TARGET not supported on this system execution statement: Start Oracle Database (startup) error: ORA-00845: MEMORY_TARGET not supported on this system error cause: because the size of SGA exceeds the size of

Some common operations of sequence in Oracle sequence are so-called serial numbers in oracle. It will automatically increase each time it is obtained, and is generally used in places where it needs to be sorted by serial number. Create Sequence you