p1

sponsored links

How to convert Oracle database component of ordinary table area table

REVIEW: In a high-availability systems, if you need to change the definition of a table is a more difficult problem, especially for 7 × 24 system. Oracle Database provides the basic syntax of the basic changes to meet the general, but for the ordinar

mssql and mysql difference of four: Stored Procedures

mssql: create procedure proc_xx3 @o varchar(100) output, @name varchar(100)='a', @nname varchar(100)='b' as declare @a int set @a = 1 select @o=xx.name from xx where xx.id=@a select * from xx where xx.name=@name or xx.name=@nname or xx.id=@a go decla

Oracle column conversion line

select p.id, wmsys.wm_concat(d.day) from plan p left join plan_day d on p.plan_id=d.plan_id group by p.plan_id From: http://cache.baidu.com/c?m=9d78d513d9d437ad4f9b96697c15c0101b4381132ba1d5020ca78438e3732b31506692e66771415a84d13b275fa0131aacb2217344

Dirty reads and non repeatable read the difference

Dirty read is read uncommitted data, and non-repeatable read that has been submitted, but the violation of consistency requirements of the transaction. http://cache.baidu.com/c?m=9f65cb4a8c8507ed4fece763104c8c205c12ca743ca081492f8ace1dd2735b36163bbca

MongoDB (4) java api

java api applications, not jdbc ah, mongodb very strange, very strange, Examples include code, commonly used to add, modify, delete, statistics, paging, conditions, documents nested query Test code import java.util.HashSet; import java.util.Set; impo

WWNN and WWPN of the concepts and AIX.HPUX on the query (original)

WWN of the HBA card with a number, each Fibre Channel device has a unique identifier, called the WWN (world wide name), responsible for the allocation by the IEEE. Use of multiple hosts in the disk array, through the WWN numbers to determine which ho

Create MySql Range partition

In MySQL, create the partition table support, the main partition types Range Division, List partitions, Hash partition, Key partition and sub-district. Used in the project recently Range partitioning the data table is partitioned; Range partitioning is ba

Oracle WMSYS Functions

Oracle WMSYS Functions Version 11.2 GENERAL Data Types CREATE OR REPLACE TYPE wm_period AS OBJECT ( validfrom TIMESTAMP WITH TIME ZONE, validtill TIMESTAMP WITH TIME ZONE); Security conn / as sysdba ALTER USER wmsys ACCOUNT UNLOCK IDENTIFIED BY wmsys; WM_

Use hibernate summary details

hibernate3.3.1 If used in hql join, then the associated order by the other table, such as order by othertable.name will complain of. If you do not join, then no problem, hibernate, and automatically help you sort associated with success. May not support t

tt the lua extension

tc: http://fallabs.com/tokyocabinet/tokyocabinet-1.4.47.tar.gz tar zxvf tokyocabinet-1.4.47.tar.gz cd tokyocabinet-1.4.47 . / Configure make make install lua: http://www.lua.org/ftp/lua-5.1.4.tar.gz make linux make install file / usr / local / bin /

Oracle clob field in the distinct operations of

oracle 10 + g does not support the type of CLOB columns distinct, do not support union, so in the face of this problem, SQL statements need to be re from another ideology to achieve the same effect. union did not carefully thought about the specific condi

windowns installation and configuration under svn

svn is a popular version of the controller, the trial configuration is simple and convenient, first download Subversion and TortoiseSVN, and then double-click the installation, both are required after the installation is complete restart the computer

Calculate distance algorithm googlemap

//private const double EARTH_RADIUS = 6378.137; // Earth RADIUS function rad(d){ return d * Math.PI / 180.0; } function GetDistance( lat1, lng1, lat2, lng2){ //p1 Latitude, longitude P1 ,p2 Latitude, longitude P2 var radLat1 = rad(lat1); var radLat2

windowns svn installation and configuration under

svn is a popular version of the controller, the trial configuration is simple and convenient, first download Subversion and TortoiseSVN, and then double-click the installation, both are required after the installation is complete restart the computer

SQL query duplicate records

Suppose a person existing table (table name: Person), if you want the name, ID number, address these three fields to find out the exact same record, the use of 1: SELECT p1 .* 2: FROM persons p1, persons p2 3: WHERE p1.id <> p2.id 4: AND p1.car

modifying layer that is being finalized

Experience modifying layer that is being finalized this question. The reason is because in my-dealloc method [Button release]; lead. Should be written: [Button removeFromSuperview]; The above problem no longer appeared. p.p1 {margin: 0.0px 0.0px 0.0px 28.

C language memory allocation analysis

(From Anonymous) A compiled C / C + + program the memory into the following sections: 1, the stack area (stack): automatically assigned by the compiler and the release of stored function parameters, local variables, and even the function call stack t

[ZT] using the PHP-FPM (PHP FastCGI Process Manager) to be on the php-cgi process management

If you use the PHP-FPM (PHP FastCGI Process Manager) to manage the process, you will need ahead of time to do the following work: First official website to download the corresponding version with php php-fpm patch: PHP-FPM Assumptions: php source dir

mysql left outer join and right outer join

See a certain connection with the left and right connections and the like, but the concept is very blurred Specifically get a bit today Simply understood as follows: Connect the left (the main table on the left and right have the same data listed) se

Historical heritage, tolerance regret

Using C / C + + years of people following a string assignment are not unfamiliar to it. char * p = "test"; At the same time, I also believe that after you use this statement has gone through tough times a lot, right? If you want to use the

oracle autonomous transaction

create or replace procedure p1 is begin update emp set ename = 'lxt888' where empno = 7788; commit; end; create or replace procedure p2 is begin update emp set ename = 'lxt888' where empno = 7934; p1; rollback; end; Result: no change,

ORA-14402 updating partition key column

DBA to do the past few years, often encountered in the project to the maintenance period always modify the table structure for the simple reason that with increasing amount of data, access to the table more and more slowly. Therefore, taking advantag

Variables like access using stored procedures

mysql v 5.0.22 CREATE PROCEDURE `p1`(in param integer) begin declare var1 varchar(20); if param = 1 then set @var1 = 'qq520'; else set @var1 = 'wunder'; end if; set @sqlstr ='select * from _userinfo where uname like ?'; prepare stmt from @sqlstr; EXE

mysql partition table of the differences between sub-

First, what is mysql points table, partition What is a sub-table, the surface meaning of the point of view, that is, to a table is divided into N number of small tables, see the specific sub-tables mysql three methods What is a partition, a table is

Query and remove duplicate data

Query and remove duplicate data Articles Category: Database If you want the name, ID number, address these three fields exactly the same record check out select p1 .* from persons p1, persons p2 where p1.id <> p2.id and p1.cardid = p2.cardid an

Installation and Usage Summary Balance

Description: balance is a load balancing software, through the specified IP-Port list of polling, to achieve a more rational and efficient use of resources. Official Website: http://www.inlab.de/balance.html 1. Download: To the official website to downloa

Database: remove duplicate records, leaving only the line

I use the SQL statement: delete from fp_sgfpxx where fphm in (select fphm from fp_sgfpxx group by fphm having count (fphm)> 1) and rowid not in (select min (rowid) from fp_sgfpxx group by fphm having count (fphm)> 1) remove duplicate invoice nu

union and the union all, intersect, minus the difference between usage and

1, union: the results of the query will return two of them and remove the duplicate parts such as: select name from person1 p1 union select name from person2 p2; 2, union all: on the table and the union as a merger, but he will not get rid of duplica

oracle partition table creation method

Oracle provides the partitioning technology to support VLDB (Very Large DataBase). Partition table to determine through the partition column, the column partition different records into different partitions. Completely transparent to the application

First experience Oracle11g partition

- Create Table create table us_pwdwronglimit ( msisdn varchar2 (11) not null, limitdate date not null, times number (3) not null ) partition by range (limitdate) interval (numtodsinterval (1, 'day')) ( partition p1 values ​​less than (to_date

oralce multi-table update method

-- Backup create table content_20110112 as select * from content; alter table content_20110112 add constraint content_20110112_key primary key(contid); -- Fall back update content t set t.products = (select o.products from content_20110112 o where o.

Their common Linux common commands

$ find . -name "*MediaScanner*" # adb push Pictures /p1.jpg /sdcard/ # cp -r out/target/product/generic/system.img out/target/product/generic/ramdisk.img out/target/product/generic/userdata.img /home/zhanglibin/program/android-sdk-linux_86/platforms/

mysql partition study notes

(The layout I sweat a... When editing a paragraph is displayed, save actually look like this...) Partition types of range, list, hash, key 1.range CREATE TABLE employees (id INT NOT NULL, fname VARCHAR (30), lname VARCHAR (30), hired DATE NOT NULL DE

The temperature detection system based on DS18B20

Microcontroller to see what the recent two days ago, made a temperature measurement system. DS18B20 to do with the sensor. And share with you. Want an expert advice. First, the circuit diagram Second, the original program /*--------------------------

Determine the prime numbers and Goldbach Conjecture

To determine whether a number is prime and verification issues Goldbach conjecture Prime numbers: Known prime number prime number. Refers to a natural number greater than 1, in addition to 1 and the integer itself, but can not be divisible by the num

Light that JavaScript closures

What is closure: Closure is a limited scope of functions is closed types of variables. Say, it seems too abstract. But at least we know three things: the closure must exist in a variable, the second point, the variable type is function. The third point: t

Seven ways to write beautiful code

1, to end if statement For example, the following JavaScript statement, it looks very terror: function findShape(flags, point, attribute, list) { if(!findShapePoints(flags, point, attribute)) { if(!doFindShapePoints(flags, point, attribute)) { if(!fi

Create an object built-in sequencer

class T { public static final Comparator namecompartor = new Comparator () { private static final long serialVersionUID =-1437640932087241702L; public int compare (Object o1, Object o2) { RuleBasedCollator collator = (RuleBasedCollator) Collator.getI

String character pointer (1)

char *p1="abcd",*p2="abcd";// If *p2="abcdef", The result is :no equal if(p1==p2) cout<<"p1 p2 equal \n"; else cout<<"p1 p2 no equal \n"; if("join"=="join") // If you "join" == "joinn", then the result is :no equal cout<<"equal \n";

typedef use and two of the four traps

http://hi.baidu.com/changfeng01200/blog/item/48ea2d3975c98f23b9998f80.html Use one: Define a type alias, not just a simple macro substitution. Can be used as a statement that more than one object pointer type. For example: char * pa, pb; / / This is

typedef four applications and two traps

http://hi.baidu.com/changfeng01200/blog/item/48ea2d3975c98f23b9998f80.html Use one: Define a type alias, not just a simple macro substitution. Can be used as a statement that more than one object pointer type. For example: char * pa, pb; / / This is

how to make pseudo-static html using apache

Rewirte main function is to achieve URL of the jump, Rewirte code is based on Perl regular expression language. Server-based class (httpd.conf) and the directory level (. Htaccess) in two ways, and we generally use the Apache directory level (. Htaccess)

MAX_TRANSACTION_RESTARTS SQL transaction restarts exceeded

-Define (MAX_TRANSACTION_RESTARTS, 10). In this configuration in ejabberd ejabberd_odbc.erl = ERROR REPORT ==== 2010-12-04 08:27:52 === E (<0.345.0>: ejabberd_odbc: 387): SQL transaction restarts exceeded ** Restarts: 2 ** Last abort reason:

Used whereis and is_pid

Eshell V5.7.4 (abort with ^ G) 1> P = self (). <0.33.0> 2> is_pid (P). true 3> register (p, P) 3>. true 4> is_pid (p). false 5> whereis (p) 5>. <0.33.0> 6> whereis (p1) 6>. undefined 7> is_pid (whereis (p1)).

Ask about erlang (sys module \ gen module) and ejabberd (p1_fsm) the timeout solutions

Recent tests found that the log always appear timeout tips. Analysis are erlang code which gen.erl module wait_resp_mon method to blame. wait_resp_mon in receive - after - Timeout, Timeout finalized is the cause here. Wrote a small program, test it, recei

About erlang (sys module \ gen module) and ejabberd (p1_fsm) the timeout solutions

Recent tests found that the log always appear timeout tips. Analysis are erlang code which gen.erl module wait_resp_mon method to blame. wait_resp_mon in receive - after - Timeout, Timeout finalized is the cause here. Wrote a small program, test it, recei

mysql partition Features

Partition some of the advantages: 1) with a single disk or file system partition than can store more data. 2) For those who have lost the meaning of the data stored, can usually be removed with the data on the partition, it is easy to delete those data. C

Partition index problem

select * from user_indexes t where t.status! = 'VALID' View failure index, index partition in the middle but shows stuts is N / A, very strange, create index DDETAIL_IP3 on T_DDETAIL_N3 (DD_IP) nologging parallel 8 local; Create a partitioned

mysqldump to export a table's data

mysqldump-uroot-p1 library watch name - where = "condition"> filename For example: mysqldump-uroot gb_gps t_gps_point - where = "c_terminal_no = 'CN651623' and c_gps_time> '2010-10-27 00:00:00 '"> aa.sql

oracle log related nologging

In fact nologging and table mode, insert mode, the database operating mode (archived / unarchived) have a great relationship: Summarized as follows: Note that append is a hint; Generally we can use insert / * + append + / into mytable values ​​(1,
Recent
Recent Entries
Tag Cloud
Random Entries