Oracle

Oracle Database PL/SQL cursor 3) cursor www.2cto.com 1. The basic principle of the cursor is to process the data results one by one. Low execution efficiency and resource occupation. 2. Whether the cursor attribute % FOUND % ISOPEN opens % NOTFOUND %

ACTIVE_INSTANCE_COUN of Oracle 10 Gb memory is used in the cluster environment. It is deemed to be null, that is, all the nodes are master nodes. Www.2cto.com is in the RAC environment of the two sites, you can configure the master and compute nodes

If you delete a piece of data from a table in oracle, you can also perform rollback by performing the rollback operation (rollback). If you want to clear the data of a table www.2cto.com, if you do not want to perform rollback, you can immediately

Oracle reset sequence Statement 2 SQL code www.2cto.com CREATE OR REPLACE PROCEDURE RESET_SEQUENCE (p_sSeqName IN VARCHAR2) IS n NUMBER (10); tsql VARCHAR2 (100 ); begin execute immediate 'select' | p_sSeqName | '. nextval from dual 'into n; n: =-(n-

When modifying a project by checking the method of recently modified tables in Oracle, it involves modifying many tables in Oracle (including adding, deleting fields, and modifying annotations ). As no records are recorded at the beginning, the

Oracle left join, right join query in Oracle PL-SQL, left join and right join in the following way to achieve www.2cto.com view the following statement: SELECT emp_name, dept_name FORM Employee, Department WHERE Employee. emp_deptid (+) = Department.

The Oracle Max function generates a strange problem when writing another stored procedure, the following SQL statement www.2cto.com SELECT MAX (RE_DATE) INTO V_RE_DATE FROM T_RECORDINGWHERE ID = '20140901' is used'It is reasonable to say that the

Oracle Learning 1 (new user and user management) encountered an error that could not check the memory when installing oracle11g. I tried various methods on the Internet and did not solve the problem. I had no choice but to reinstall the system,

The Oracle drop table and delete table recovery operations share these experiences to help the same people who have made mistakes. The first problem is: drop table, remember to restore www.2cto.com without purge: flashback table tableName to before

The method for oracle to view the table name through the constraint name is that the exception is not dba first, but it is good to know more about oracle. To know which table an index belongs to, run the following SQL statement: select TABLE_NAME

For some reason, we need to create dozens of tables with similar structures in Oracle and start with DEL _ to record the cleaned data during data cleaning. For example, table 1 corresponds to DEL_TABLE1, but unfortunately, the PDM file is

Transport tablespace moves data in one tablespace to another tablespace 1. create two tablespaces SQL> create tablespace test1 datafile '/opt/test1.dbf' size 10 m; www.2cto.com Tablespace created SQL> create tablespace test2 datafile '/opt/test2.dbf'

Sqlplus uses sqlplus to query data by adjusting the output width. It is often difficult to query data in different branches, which requires adjusting the output width. The adjustment includes the length of the entire output row and the width of a

How to thoroughly uninstall oracle close all oracle services and programs Select Start | program | oracle Installation Products command, run Universal Installer, pop up the welcome dialog box www.2cto.com single-host uninstall product button, in the

I recently used PLSQL to print the calendar. After reading it, the concept suddenly feels empty. Not much gossip. I used PLSQL to write a calendar printing function. Www.2cto.com [SQL] create or replace package display_date is procedure display_spec_

Oracle creates a trigger to insert a stored procedure into the memory to improve computing efficiency. Create the Stored Procedure SQL> @... \ dbmspool. SQL check whether the package has created SQL> desc dbms_shared_pool www.2cto.com create trigger

In oracle, a select statement is used to list query results that meet multiple conditions. SELECT p. product_directory_level, COUNT (case when p. product_directory_level = 1 THEN 1 www.2cto.com else null end) material, COUNT (case when p.

The method of appending database files to the tablespace in the oracle database is applicable to non-large files. The maximum size of a single file is 32 GB. The first method is as follows: add a data file to the tablespace: www.2cto.com 1. alter

Create or replace procedure statement is begin DECLARE -- query A set of www.2cto.com CURSOR c_number is select number186, money186 from xh_number_186_t A where. number186 in (select n. number186 from xh_number_186_t n minus select t. service_id

Test preparation for code encapsulation in the trigger: www.2cto.com [SQL] hr @ ORCL> drop table t purge; Table dropped. hr @ ORCL> create table t (code number); Table created. hr @ ORCL> create table t_audit (code number, ins_date date); Table