oracle data quality for data integrator

System Environment:1. Operating System: Windows 2000 server,2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition3. installation path: C: \ oracle Error:A data file in the database was accidentally deleted due to misoperations,The Oracle-related services on the control panel are displayed as started, but cannot

Data per day in oracle statistical period (recommended), oracle per day The following describes the data of each day in the oracle statistical period. The specific SQL statement is as follows: 1. generate 1000 RANDOM numbers select rownum rn, DBMS_RANDOM.VALUE (0, 1000) rand

If it is Oracle 10g above a wm_concat function can be solved.It's a bit of a hassle if you're under Oracle 9i.The table structure is as follows:NAME Null Type--------------------------------- -----n_sec _code notNULLCHAR(6) C_researcher_code not NULL VARCHAR2 ()This table holds data on the correspondence

Oracle uses a cursor to delete all record scripts in all user data tables. oracle cursor Application Scenario: because the data in the database involves confidential information, we hope to delete all the data at a time and only keep the

Tags: OracleORA-01578 is a block of physical bad blocks/corruption, different from the logical corruption/bad block, usually accompanied by ORA-1110 appear, once Oracle read to the existence of a corrupted block will be reported caused By:java.sql.SQLException: Ora-01578:oracle Data Block Corruption (file number 4, block number 840339)ORA-01110:

VARCHAR2 (20), Userpwd varchar2 (20), Email VARCHAR2 (30), RegDate Date ); Delete a table --delete the structure of the table DROP TABLE table_name; Add Field ALTER TABLE table_name add column_name datatype; TABLE_NAME is the table name, COLUMN_NAME is the column name, datatype is the data type 4. Modify table field name and name --Renaming a field ALTER TABLE table_name rename column column_name to new_column_name; --Modify the name of the table Re

In oracle, the month or part of data is obtained from the specified date. The oracle date Obtain part of the data from the specified date: Such as month: Select to_CHAR (sysdate, 'mm') from dual; Or: Select extract (month from sysdate) from dual; Or the most stupid method, use to_char () to first convert the date

ORACLE-004-read duplicate data in a column, oracle-004-read SELECT primary key or columns that can represent the current row FROM (SELECT primary key or columns that can represent the current row, repeated columns, row_number () OVER (partition by repeated column order by repeated column DESC) rn from tableName) where rn = 1 is read as unique and duplicates are

When you activate a constraint using the Enable VALIDATE option, the error message is prompted if the data already exists that does not meet the constraint rule, and the activation constraint fails. The existing data must be corrected at this time, ensuring that the data is fully mouthed with the constraint rules. The specific methods are as follows: (1) Establi

Oracle cross-database query replication table data distributed query, oracle Method 1: Currently, most databases require distributed queries. The following describes how to configure cross-database access in oracle. For example, there are two database servers and two databases are installed. Database server A and B. No

Oracle performance analysis 6: Index scanning of data access methods, oracle Index This section describes various index scanning methods. After learning about the features of various index scanning methods, you can determine whether the scanning methods used in your execution plan are correct, you can also make improvements to the obtained information.Unique inde

Ora-12705:cannot Access NLS data files or invalid environment specified error Install no Oracle client connect oracle9i, 10g, 11g using Pl/sql,toad for Oracle As we all know, oralce client hundreds of trillion too large, online also has a lot of dir processing. The processing here is provided by the official Oralce Toolkit instant Client package! Download Address

operations: bash-2.03$ EXPDP Zhejiang/zhejiang directory=d_test DUMPFILE=ZHEJIANG.DP Export:release10.2.0.3.0-64bit Production on Monday, 20 April, 2009 0:51:13 Copyright (c) 2003, +, Oracle. All rights reserved. Connect to: Oracle database10genterprise Edition release10.2.0.3.0-64bit Production With the partitioning, real application clusters, OLAP and Data