Error logs recorded during DML Process
When you insert millions of data records, the insertion fails due to several dirty data records. Oracle 10g R2 has a new feature that inserts records that failed to be inserted into another table.
SQL> drop table test purge;
SQL> drop table test_bad purge;SQL> create table test as select * from dba_objects where 1
SQL> execute dbms_errlog.create_error_log ('test', 'test _ bad ');
Create table TEST(OWNER VARCHAR2 (30 ),OBJECT_NAME VARCHAR2 (128 ),SUBOBJECT_
optimized at the SQL level, we can consider vertical data splitting. Here is an experiment:
-- Manufacturing data is not vertically split
Create table test (
A number,
B varchar2 (4000 ),
C varchar2 (4000 ),
D varchar2 (4000 ),
E varchar2 (4000 ),
F varchar2 (4000 ),
G var
SourceAddress:
IP Destionation Address:
Options: optional field. Padding indicates that 32 bits is not enough to be filled with 0.
For example, I caught such a package with tcpdump:
00:05:36. 631501 IP localhost.54504> localhost.9889:Flags [P.], seq 4289908547: 4289908560, ack 2355231328,Win 2050, options [nop, nop, TS val 28499978 ecr 28495907], length130 × 0000: 4500 0041 1f63 4000 4006 1d52 7f00 0001 E... A. c @. @. R ....0 × 0010: 7f00 0001 d4e
First, create a table named chineseword (simpleword, traditionword) that stores simplified and traditional Chinese characters)
Then, write a stored procedure to insert data into the chineseword table.
Create or replace procedure insertchineseword iss_str1 varchar2 (4000); s_str2 varchar2 (4000); s_str3 varchar2 (4000); s_str4 varchar2 (
the compilation function as follows:Pattern = r '''Foo
Bar'''Regex = re. compile (pattern, re. VERBOSE)When processing more complex regular expressions, spaces and comments are more important. Assume that the following regular expression is used to match the telephone number in the United States:\(? \ D {3 }\)? ? \ D {3} [-.] \ d {4}This regular expression matches the phone number in the form of "(314) 555-4000". Do you think this regular expression
"/foo|bar/" becomes the following form:
"/
Foo
Bar
/x "
In the Python language, pass the schema modifier parameter "re." VERBOSE "gets the compiled function as follows:
Pattern = R ' '
Foo
Bar
'''
Regex = Re.compile (pattern, re. VERBOSE)
Spaces and annotations are more important when dealing with more complex regular expressions. Suppose the following regular expression is used to match the U.S. phone number:
\ (? \d{3}\)?? \d{3}[-.] \D{4}
This regular expression matches the phone number in
$ varchar2 (2000) oracle error message textOra_err_rowid $ rowid Of The Wrong row (for update and delete)Ora_err_optyp $ varchar2 (2) Operation Type: insert (I), update (u), delete (d)Note: errors in the update and insert clauses of merge operationsDistinguish between U and IOra_err_tag $ varchar2 (2000) label value provided to the error logging clauseBytes --------------------------------------------------------------------------------------------------------------Table: column data type of th
1. Start to restore the original paging stored procedure.
Copy codeThe Code is as follows: alter procedure [dbo]. [sp_ SQL _Paging]
(
@ SqlDataTable NVARCHAR (4000), -- table name
@ PrimaryKey NVARCHAR (4000), -- primary key name
@ Fields NVARCHAR (4000), -- the field to be returned
@ PageSize INT, -- page size
@ PageIndex INT, -- page number
@ RecordCount int ou
Php
5000~7000
2000~6000
8000~9000
4000~8500
5000~7000
How are these random sets of data in PHP more effective in judging if there are duplicates?
Expectations are
2000~4000
4000~5000
5000~6000
6000~7000
7000~8500
8500~9000
Reply to discussion (solution)
This post was last edited by xuzuning on 2013-10-09 09:00:13
$a = Array (array (7000), array (6000
1. Start the restore below first look at the original paging stored procedures.
Copy Code code as follows:
ALTER PROCEDURE [dbo]. [Sp_sql_paging]
(
@SqlDataTable NVARCHAR (4000),--table name
@PrimaryKey NVARCHAR (4000),--primary Key name
@Fields NVARCHAR (4000),--the field to be returned
@pageSize INT,--page size
@pageIndex INT,--page number
@
NAT principles and NAT traversal technical principles and implementation recently, when reading things, I found that many network programs need NAT traversal. I would like to summarize it here. First, make an agreement: Intranet A has: A1 (192.168.0.8), A2 (192.168.0.9) Dual-user gateway X1 (a nat device) has A public IP address 1.2.3.4 Intranet B has: B1 (192.168.1.8) b2 (192.168.1.9) dual-purpose users, Gateway Y1 (a NAT device) has a public IP address 1.2.3.5 public network server: C (6.7.8.9
compilation function as follows:Pattern = r '''FooBar'''Regex = re. compile (pattern, re. VERBOSE)When processing more complex regular expressions, spaces and comments are more important. Assume that the following regular expression is used to match the telephone number in the United States:\(? \ D {3 }\)? ? \ D {3} [-.] \ d {4}This regular expression matches the phone number in the form of "(314) 555-4000". Do you think this regular expression match
this feature? The regular expression of Perl 6 defaults to the space extension mode. Do not extend the space for your language by default. take the initiative to use it.One of the tricks to remember to expand spaces is to let the regular expression engine ignore the extended space. In this way, if you need to match spaces, you have to explicitly describe them.In Perl, add x to the end of the regular expression, so that "m/foo bar/" becomes the following form:
M/Foo Bar/X
In PHP, add x to the en
} [-.] d {4}
This regular expression matches the phone number in the form of "(314) 555-4000". do you think this regular expression matches "314-555-4000" or "555-4000? The answer is that the two do not match. Writing such a line of code hides the disadvantages and design results. The telephone area code is required, but the regular expression lacks a description
extended space. In this way, if you need to match spaces, You Have To explicitly describe them.In Perl, add x to the end of the regular expression, so that "m/foo bar/" becomes the following form:
M/Foo Bar/X
In PHP, add x to the end of the regular expression, so that ""/foo bar/"is changed to the following form:
"/Foo Bar/X"
In Python, the pass mode modifier parameter "re. VERBOSE" gets the compilation function as follows:
Pattern = rFoo BarRegex = re. compile (pattern, re. VERBOSE)
When proce
This article mainly introduces parameter passing and calling of setTimeout and setInterval functions in JavaScript, two functions can insert the code to be executed into a code queue maintained by the js engine at a set time point. For more information, see
How to pass parameters to setTimeout and setIntervalSee the following code:
var str = 'aaa'; var num = 2; function auto(num){ alert(num); } setTimeout('auto(num)',4000);
In this way, the writ
-- SQL decryption ctext field Content Function-- Exec sp_decrypt 'constraint name'-- Exec sp_decrypt 'df _ insurancerecord_periodunit'-- Exec sp_decrypt 'stored procedure name'-- Exec sp_decrypt 'SP _ searchprinting_insurancerecord'
-- Main purpose: Read the field content in systemcomments. Including constraints and stored procedures.
-- The original text should be from idea. Saving me a lot of time. I was going to first find the crack Function in the ox character transfer format, or the conten
How to pass parameters to SetTimeout, setintervallook at the following code:
var str = ' AAA ';
var num = 2;
function Auto (num) {
alert (num);
}
SetTimeout (' Auto (num) ', 4000);
This is a good way to write, but as it says this is a parameter pass, it's more of a global variable that is used directly. Therefore, this writing is not necessary, in general, more is used to pass local variables as parameters.
Modify the code:
application environment. The maximum value I tested is "1 + 1 equals 1.8. In particular, if there is only one broadband or multiple sub-accounts using "My ehouse", dialing will not achieve the effect of bandwidth superposition. In addition, the effect of multi-task download bandwidth overlay is more obvious.
TIPS: Which routers can enjoy the new firmware version of the tomato DualWan router?
Vrouters such as TP-link, tengda, and Alpha cannot use Tomato DualWan. For more information about the su
With the development of China's routing industry, Cisco Wireless routers are also widely used. Here we mainly introduce a beautiful Cisco Wireless Router WRT54G2, last year, Cisco Consumer Division launched a newly designed 54M wireless route Linksys by Cisco WRT54G2. The elegant and slim design conforms to the current fashion trends of home entertainment and SOHO offices. Currently, this product is priced at 350 yuan in the market. It is very suitabl
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.