Oracle

/*abs (N)Returns the absolute value of the value specified by the parameter n (if the parameter value is NULL, the returned result is null, the same as below). */--select ABS ( -3.14) from DUAL; --3.14/*round (n[, M])Returns the result of rounding

Common SQL statements:Select To_char (sysdate, ' Yy-mm-dd hh24:mi:ss ') from dual; Display: 08-11-07 13:22:42Select To_date (' 2005-12-25,13:25:59 ', ' Yyyy-mm-dd,hh24:mi:ss ') from dual; Display: 2005-12-25 13:25:59Get system time:Select Sysdate

To the Oracle Web site to download the direct client, http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html contains Oci.dll , Orannzsbb10.dll,oraocci10.dll,oraociei10.dll four DLL files, where Oraocci10.dll must be

-PrincipleNulls first and Nulls last are the syntax supported by the Oracle order by, if an expression is specified in order by, the record that represents a null value is ranked at the top (either ASC or DESC) If the expression is specified in the

/* There is a route, no BOM */Select Msi.segment1,Msi.descriptionFrom apps. Bom_operational_routings Bor,Apps.mtl_system_items_b MSIwhere msi.organization_id=yand bor.organization_id=msi.organization_idand

SELECT DISTINCTMsr.sourcing_rule_name Name, msi.description description, Msi.item_type type, Msi.inventory_item_status_code status, the Msr.planning_active program takes effect, msro.effective_date Effective Date, Msro.disable_date Invalid Date,

SelectFu.user_name User Name,Fu.description User Description,Frv. Responsibility_name Responsibility Name,Request_group_name Report Group,(select PPF. Full_nameFrom Apps.per_people_f PPFwhere fu.employee_id = PPF. person_idand Trunc (sysdate)

SelectMSI.SEGMENT1 Assembly Parts Code,Msi.description Assembly Parts Description,Bos.operation_seq_num serial number,Bso.operation_code Operation Code,Bd.department_code Department,Bos.operation_description procedure

Sequence: A sequence is a data object that can be used to generate a unique integer. is a separate object in the database, not dependent on any tables, unique to Oracle. Used to automatically generate primary key values, you can use sequence: The

SELECT DISTINCTMsr.sourcing_rule_name name,Msi.description description,Msi.item_type type,Msi.inventory_item_status_code State,Msr.planning_active plan comes into effect,Msro.effective_date Effective Date,Msro.disable_date Invalid

/* Deadlock Query -1*/SELECT O.object_name,L.session_id,l.process,L.locked_mode from V$locked_object L,Dba_objects o WHEREo.object_id=l.object_id------------------------------------------------/* Deadlock Query -2*/ Select GL. session_id,         

Oracle Database Performance Optimization general rule:One, reduce data access (reduce the number of drive room visits)Second, return less data (reduce network transmission or disk access)Third, reduce the number of interactions (reduce network

First, the concept1. Databases (database)What is a database?A database is organized according to a data model and holds data sets in Level two memory.This collection of data has the following characteristics:As little as possible, the best way to

1. Create a DirectorySql> Create directory Dump_file as '/db/backup ';2. Directory-assigned PermissionsSql> Grant Read,write on Directorydump_file to BAM;View CatalogSql> select * from Dba_directories;3. BackupSQL>EXPDP user/pwd

Article Source: http://www.cnblogs.com/leijh/archive/2012/10/15/2724165.htmlThe recent height of the program is always found to execute the operation of the database code when found to execute, checked the discovery is the database table lock dead

Possible causes and solutions for ORA-27302: failure occurred at: skgpspawn3 Symptom: Mon May 26 07:08:58 GMT + 08:00 2014 Process startup failed, error stack:Mon May 26 07:08:58 GMT + 08:00 2014 Errors in file/oracle/app/admin/oracle10/bdump/oracle1

I. oracle logical architecture Diagram Ii. Logical Structure The logical structure of oralce includes: 1. tablespace 2. Segment 3. Zone 4. Block The oracle database consists of several tablespaces. The tablespace consists of several

1. index creation Syntax:Create uniuqe | bitmap index . ON . (| ASC | DESC, | ASC | DESC ,...)TABLESPACE STORAGE LOGGING | NOLOGGINGCOMPUTE STATISTICSNOCOMPRESS | COMPRESS NOSORT | REVERSEPARTITION | global partition Description1) UNIQUE | BITMAP:

In Oracle, the insert ALL statement is described as follows: 1. insert all unconditionally   Create table t1 (product_id NUMBER, product_name VARCHAR2 (80), month number); insert into t1 VALUES (111, 'apple', 1); insert into t1 VALUES (222, 'orange'

In recent years, Oracle database systems have become increasingly favored by ctos. With their excellent data delivery capabilities and the operational capabilities of CEO Larry lison, the powerful and complex Oracle database has been favored by