Oracle

How to find similar records in the database [problem] There are a large number of duplicated data entries in the business system due to preliminary design reasons, and the names of repeated entries need to be removed now.However, these names are

Task Plan-RMAN Delete expired backup crontab-l www.2cto.com Crontab code oracle @ ntsmshost :~ $ Crontab-l # m h dom mon dow command 20 1 ***/data/scripts/shell/expdp_ntsmsall2.sh 01 1 ***/data/scripts/shell/rmn_del_obsolete.sh vi/data

Oracle spatial sdo_buffer function precision control SDO_GEOM.sdo_buffer function is used for buffer query. It has three parameters: www.2cto.com param1: the geometric element to be queried. Param2: the geometric elements used for filtering. Param3:

The number of active cursor cursqueries SQL [SQL] www.2cto.com select allcursor all cursors, MYALLCURSOR my cursnumber, myopencursor I open cursnumber, MYCACHECURSOR my SESSION cache cursnumber, (MYALLCURSOR-MYOPENCURSOR-MYCACHECURSOR) Number of my

Oracle caller and definer permissions 1. In the first case, the owner or definer of the PL/SQL program reserves all permissions for program execution. You can use the authid definer keyword in the nameprogram www.2cto.com header to enable any user

Oracle dbms_random functions use 1. Package definition: www.2cto.com SQL> desc transaction Type ---------- --------- SEED PROCEDURE VALUE FUNCTION NORMAL FUNCTION STRING FUNCTION INITIALIZE PROCEDURE RANDOM FUNCTION TERMINATE PROCEDURE NUM_ARRAY

You do not need to set the expiration time of the Oracle 11G account during the development process. Www.2cto.com 1. Check the user's proifle, which is generally default: SELECT username, profile from dba_users; 2. Check the password validity period

 1. Usage description the dbms_xplan package is used to display the execution plan. The execution plan is stored in the Schedule, database cache, and AWR. dbms_xplanThe package can extract the execution plan from these locations, format it, and

Comparison of Oracle temporary table usage temporary tables is a common means of complex SQL Performance optimization. Www.2cto.com 1) Global Temporary sentences can be divided into sessions and transactions. Session-level Temporary Table [syntax]

Three BOOLEAN values of PL/SQL: TRUE, FALSE, and NULL. The BOOLEAN type in Oracle PL/SQL has three values: TRUE, FALSE, and NULL. These three values cause unnecessary trouble during development, such as www.2cto.com [SQL] DECLARE B _FLAG_TRUE

The configuration file sqlnet. ora/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet. ora listens to www.2cto.com/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.

Oracle configuration catalog 1: Create a tablespace in the catalog Database: export Oracle_SID = ORCLcreate tablespace rmants datafile '/home/oracle/rman/rmants. ora 'size 20 M; Note: The tablespace name must not be rman. If it is rman, an error

Oracle ratio_to_report function Syntax analysis function RATIO_TO_REPORT is used to calculate the percentage of the index expr of the current record to all the same metrics of the record contained in the over window function. here, if the

Oracle user-defined functions return a table type. The following is a simple example. To copy data to the oracle database, you can use www.2cto.com 1, 2, create or replace type t_test as object (id integer, rq date, mc varchar2 (60) 3. create or

In PL/SQL, the problem of "ORA-06533: the number of tables in the following Table exceeded" is solved. VARRAY is a type introduced at Oracle8G and is a dense filling array, it is easier to be understood as a traditional array. When creating these

Use DBMS_FILE_TRANSFER to migrate tablespaces and data files in ASM. This is a stored procedure package and a toolkit for executing migration tasks besides RMAN,You can complete the following migration: ASM-> ASM, ASM-> OS Flie, OS File-> ASM, OS

Common tables for Oracle testing: create tables for test using BIG_TABLE, which is often used by DBAs. Generally, many tables are created based on dba_objects. This article is based on the big_table of Master Tom for your reference. Www.2cto.com 1.

Oracle Database (table) logical backup and recovery Oracle backup, recovery of single or multi-table data steps Oracle backup, recovery of single or multi-table data steps, applicable to Oracle 8, 9, and 10. * Back up single or multi-table data: www.

Oracle Data files shrink with the use of the database, the data files become larger and larger. Is there a way to squeeze out the relevant table from the block marked as free: www.2cto.com DBA_DATA_FILESDBA_DATA_FILES describes database files.

Oracle uses the user_db_like Stored PROCEDURE Java code create or replace procedure hello as -- Define the parameter www.2cto.com -- to get objectid cursor Cursor_Objectid is select id from (select a1.id from distinct a1 union select b1.id from