Oracle

Delete a large table when the space is not released, very slow because of a large amount of system resources, support fallback operation, space is also occupied by this table. TRUNCATE TABLE name (frees table space when records are deleted from a

The author believes that when creating an index, it is three appropriate to create an appropriate number of indexes on the appropriate table and on the appropriate columns. Although this can be summed up in a sentence to optimize the basic criteria

(1) oracleservicesid Database service, which automatically starts and stops the database. If a database is installed, its default startup type is automatic. The service process is ORACLE.EXE, parameter file initsid.ora, log file SIDALRT.log,

Duplicate data can be in two cases, the first: only some of the fields in the table, and the second is exactly the same as two rows of records. one, for partial field duplicate data deletion 1. Query for duplicate dataSelect field 1, Field 2, COUNT (

Meaning explanation:Decode (condition, value 1, return value 1, value 2, return value 2,... Value N, return value N, default value) The meaning of the function is as follows: Copy Code code as follows: IF condition = value 1 THEN

(1) View character set (three is equivalent) Copy Code code as follows: SELECT * from v$nls_parameters where parameter= ' Nls_characterset ' SELECT * from nls_database_parameters where parameter= ' Nls_characterset ' SELECT * from

Type Meaning Storage description Note CHAR Fixed-length strings Max length 2000bytes 　 VARCHAR2 Variable-length strings , Max length 4000bytes Maximum length of the index can be 749

Syntax for adding fields: ALTER TABLE tablename Add (column datatype [default value][null/not null],....); Modify the syntax of the field: ALTER TABLE tablename modify (column datatype [default value][null/not null],....); Syntax for deleting a

1. Get database name and date createdSELECT name, created, Log_mode, open_mode from V$database; 2, the Oracle database computer host name, Oracle database instance name and Oracle Database management system version informationSELECT host_name,

First, start data$sqlplus "Sys/pass as SYSDBA"Sql>startup Second, start the listenerAfter the database is started, if the listener process is not started, the client cannot connect to the database. The Start method for the listener process

Data Guard offers two main services:1 Redo Transport Service: The Primay end of the redo log transmission to one or more standby destinations.2 Redo Application Service: The redo log which is transmitted from the Primay end is applied to the standby

The schematic diagram is as follows: Control file: A file (the most important file) used to control how data is imported. Parameter file (optional) Data files: Flat file where source data is placed Error files: Putting data that cannot be

Looking at PD, double-click a table, view its preview label, and then find the CREATE statement for a table, as follows: Copy Code code as follows: CREATE TABLE Company_info ( company_id NVARCHAR2 (m) not NULL, area_id NVARCHAR2 (50),

1, in the report page layout corresponding position to add a text box, generally for download Right-click the Pl/sql Editor to write a hyperlink and add the following: Copy Code code as follows: Function B_13formattrigger Return

Meaning explanation: Decode (condition, value 1, return value 1, value 2, return value 2,... Value N, return value N, default value) The meaning of the function is as follows:IF condition = value 1 THENreturn (translation value 1)elsif condition =

The Recycle Bin (recycle) is, in principle, a data dictionary table that places the database object information that the user deletes (drop). The object that the user is deleting is not deleted by the database and still takes up space. Unless the

There are two ways: One is declaring a system cursor, one is declaring a custom cursor, and then the following action, the parameter type is In out or out (1) Declare a personal system cursor. Recommended Copy Code code as follows:

The following SQL statements can be used in Pl/sql to query which tables in the current database are locked and which users lock them: SELECTA.owner,--object owned userA.object_name,--object name (table name)B.XIDUSN,B.xidslot,B.XIDSQN,B.SESSION_ID,

I used to connect remote oracle8.0.5 for NT Enterprise version with PHP, not with Odbc,oracle interface. I'm too desperate! Looking for, and finally found the right way to connect, I use the OCI Interface, ODBC and Oracle or not to find%m epiphyseal?

The CentOS system is installed with basic Server. There are a number of missing components required before you install Apache, and here's a list of the components that need to be installed Apache-aprapache-apr-utilperl-pcreapache Website download