Oracle

--、、、、、、、、、、、、、、 Common single-line function 、、、、、、、、、、、、、、、、、、、、、、-------------------commonly used character functions------------------------initcap (char): Capitalize first letterSelect Initcap (' Hello ') from dual--lower (char): Convert to

Oracle SQL statement Tracking1 SQL statement TrackingThe execution of the trace SQL statement takes place on the Oracle server side, and the Oracle server detects and records all SQL statements executed by the access process. The commands used below

I. Import and export the remote Oracle databaseAn example of its syntax is as follows:imp/exp [username[/password[@service] ], where service is the name of the services instance, about how to createService instance name or database SID is logged in

Version info: CentOS6.5 + oracle11g1, monitor color error: + MB. 13199 mb . 3071 MB of colors >>> command/usr/bin/xdpyinfo not available Automatically check the display color. Check to see if the DISPLAY variable is set. failed

Inserting a date value using a specific formatInsert intoEMPValues(7950,'Zhangsan','MANAGER','7782', To_date ('1988-11-11','YYYY-MM-DD'),1200.00,50.00,Ten);Insert intoEmpvalues(7951,'Zhangsan','MANAGER','7782', To_date ('1988/11/11','YYYY/MM/DD'),1

Issue: The updated UPDATE statement is always updated where the card is executing the UPDATE statement.Methods to clear:Oracle Table Deadlock CancellationI'm working on plsql. 1. Query select * from V$locked_object V, dba_objects o where v.object_id

One: An optimization approach to SQL statements1. Select the appropriate Oracle Optimizer(1). RBO optimization based on rules --oracle 10G was thrown away(2). CBO optimized optimizer based on cost (CPU and memory occupancy) - The model used by the

Refer to Article http://www.cnblogs.com/wangsaiming/p/3688141.htmlMicrosoft Windows XP [version 5.1.2600](C) Copyright 1985-2001 Microsoft Corp.C:\Documents and Settings\administrator>sqlplus/nologSql*plus:release 9.2.0.1.0-production on Monday May 4

First, the indexIndexes are a quick way to access data to improve database performance. Indexing makes it possible for a database program to find the data it needs without having to scan the entire table, like a book's directory, to quickly find the

Objective: To monitor the validity of an Oracle index to see if the index is used. The index is then deleted or adjusted based on the monitoring results.Steps:1. Monitoring the specified indexCommand: Alter INDEX index name monitoring usage; such as:

1, CREATE table space, table space name is database, directory is datafile ' d:\oracle\product\10.2.0\oradata\data01.dbf ', size is 100M, each auto expansion 10M, maximum unrestricted. Create tablespace database datafile '

Before feeling installed 11g feel quite casual, today re-Ann once, out several times wrong, very uncomfortable ah, all the process recorded.After downloading the two compressed files into a folder, click Setup.exe to start the installation, if your

Query All Users: SELECT * from all_users; register monitoring manually: Alter system register;oracle password expiration setting 1, query select * from Dba_profiles where profile= ' Default ' and Resource_name= ' password_life_time ';  2, lifting

One: Package definition (includes 1. Package Specification 2. Package Body )A package is a database object that encapsulates the related PL/SQL types, subroutines, cursors, exceptions, variables, and constants.1, Package Specification: You can

One: definition of functionA function is a PL/SQL program block that returns a specific data(The function must return a value)　　Grammar:create [or replace] function function_name--functions name[(Parameter_list)]--function list or parameterReturn

Select Sid, CJSJFrom BASE_ZJXXwhere CJSJ = to_date (' 0001/1/1 ', ' yyyy/mm/dd ');SELECT *From Sys_userwhere Qyid in (90656, 90655, 90646, 90641, 90636, 90633, 90631);UPDATE base_zjxxSET CJSJ = (caseWhen Zjid = ' 90656 ' ThenTo_date (' 2015/4/7 15:57

About Oracle Cluster RegistryAbout Oracle Cluster RegistryOracle Cluster Registry (OCR) is a file that contains information about the cluster node list and instance-to-node mapping information. OCR also contains information about Oracle Clusterware

Oracle Memorandum 1 Database Administrator: Install and upgrade the Oracle database to create a database, tablespace, table, view, and index... Develop and implement backup and repair plans database permission management, tuning, and troubleshooting.

Oracle-1-InstallationI. Environment preparation1.1. DescriptionWorking path/data/hdfs/data1/jianxin/1.2. Software VersionOracle-xe-11.2.0-1.0.x86_64.rpm.zip1.3 modify tmpfs1.3.1. oracle XE provides the minimum requirement in the init. ora file. The

Description of the format parameter and rmanformat parameter corresponding to rman Replace the format variable. Note the case sensitivity! 1.% d -- db_name of the database 2.% n -- db_name with 8-bit length of the database. Fill the remaining part