Oracle

Oracle Common Statement Collation　　A large database job has been done recently. Encountered some problems, in the online search is very hard, so, will be some of the commonly used statements recorded, convenient for everyone to learn. are some basic

Reprint: http://www.cnblogs.com/baiyixianzi/archive/2012/08/30/plsql12.htmlFirst, the grammar is roughly written: select * from some_table [WHERE Condition 1] connect by [condition 2] start with [condition 3]; The order in which the connect by and

Partition table has a lot of advantages, to Dahua small, a small, coupled with the use of parallel, in the LOAP can often improve the effect of dozens of times times or even hundreds of times times.Of course the design of the table is not good also

Oracle never archives logs to archive log:sql> shutdown immediate;The database is closed.The database has been uninstalled.The Oracle routine has been closed.sql> startup Mount;The Oracle routine has been started.The database is loaded.sql> ALTER

witht1 as (selectlevelid, ‘201507‘|| lpad(level, 2, ‘0‘) col    fromdual  connectbylevelt2 as (select0 id,         null,         to_char(trunc(to_date(col, ‘yyyymmdd‘), ‘month‘), ‘yyyymmdd‘) end_dt    fromt1   whererownum = 1  unionall  select32,    

Oracle gets this week, this month, the season, the first day of the year, and the last day--This weekSelect Trunc (sysdate, ' d ') + 1 from dual;Select Trunc (sysdate, ' d ') + 7 from dual;--This monthSelect Trunc (sysdate, ' mm ') from dual;Select

The REGEXP_INSTR function lets you search for a regular expression pattern string. The function uses the characters defined by the input character set for string calculations.It returns an integer that indicates the start or end of the matching

The first part--36 10 BinaryCreate or Replace function f_36to10(STR varchar)returnintIsReturnValueint;STR36 varchar(36);Subwork varchar(1);Workindexint;Lenint;Iint;Beginreturnvalue:=0;STR36: =' 123456789Abcdefghijklmnopqrstuvwsyz‘;I: =1;Len: =

I. ORACLE Physical Architecture Principle Structure diagram Each part explains:PGA: Private memory area for use by the current initiating user only.Three effects The session information after the user logs in will be saved in

1, whether to open the Audit function queryShow parameter AuditNAME TYPE VALUE------------------------------------ ----------- ------------------------------Audit_file_dest string/home/oracle/app/oracle/admin/Orcl/adumpAudit_sys_operations Boolean

When installed by default, a PL/SQL external program (EXTPROC) entry is installed in Listener.ora, which is the listener for Oracle to invoke the default configuration of the external program, whose name is usually ExtProc or PLSExtProc650)

Exp Zdxk/[email protected] tables= (MS_DATA_DICTORY_DEF,MS_STATIC_DATA_DEF) file=c:\staticdata.dmpExport by entering the EXP command and your username/passwordThe action prompts you to enter the parameters:For example: EXP Scott/tigerAlternatively,

--api-fnd_user_pkg.createuser----example-- -- ----------------------------------------API to CREATE FND User-- -------------------------------------- DECLARELc_user_name VARCHAR2 (+): = ' quanweiru_test1 ';Lc_user_password VARCHAR2 (+): = ' Oracle123

Use Flashback to view Oracle Table historical moment data1. View the table history moment dataSELECT * from Tab_test as of TIMESTAMP to_timestamp (' 20140917 10:00:00 ', ' yyyymmdd hh24:mi:ss ');2. Use Flashback table to restore the tables to a

CREATE TABLE T_name (ID number,name varchar2 (Ten));d ROP Table T_name;select * FROM table_name where id = 2; INSERT INTO tabl E_name (C_01,C_02) VALUES (1, ' Terry '); update table_name Set name = ' Tyron ' WHERE id = 1;delete from table_name where

Http://zhidao.baidu.com/link?url=wY9qYTQHX7YksWmE9LtF4UIOkJgCDi8mXS7XkWi9u0GcD9dh0Evr7OHVzSsPDZAH6F258S4b3KAdkKvKLoPVOqhttp://blog.csdn.net/thinkscape/article/details/7411012:+++++++++++++++++++++++++++++Steps:--Create tableCREATE TABLE

[Translated from mos] How to Find the database and user name used by OGGDirectorServer?Applies to: Management Pack for Oracle GoldenGate-Version: 1.0.0.0-Release: 1.0Information in this document applies to any platform.Activity

Frequent alerts for crsd. log of ORACLE RACOracle rac environment, x86_64 Oracle 10.2.0.1, crsd. frequent log Warnings: 00:39:14. 723: [CRSEVT] [2707291024] 0 CAAMonitorHandler: 0: Action Script for resource 'ora. RAC. RAC1.inst 'stdout redirection

Unlock database users1. log on to and unlock the account with the dba role. First, set the specific time format to view the specific time. SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; Session altered. 2. Check the lock time

Implementation of Oracle's INSTR function MySQLIn a migration project, the instr function of MySQL can only find whether the child string is in the parent string. Here I wrote one for migration. Of course, here I only focus on migration, and may not