Index_name,status from user_indexes where table_name= ' TP2 ';Select Index_name,partition_name,status from user_ind_partitions where index_name= ' idx_tp2_c2 ' ORDER by Partition_name ;After checking, add partition has no effect on global and local indexes, such as:So, split partition:ALTER TABLE TP2 SPLIT PARTITION p1 at (3) into (PARTITION P1, PARTITION p13);Finding the
Learn the most commonly used test exec match search replace split 6 methods
Definitions and usageThe test () method is used to detect whether a string matches a pattern.
GrammarRegexpobject.test (String) parameter descriptionString required. The string to be instrumented.
return valueReturns True if string strings contain text that matches regexpobject, or fal
Learn JavaScript regular Good Article one: http://www.cainiao8.com/web/js_note/js_regular_expression.html
Test : Tests whether a string contains a matching result, contains return true, and does not contain return false.
Match : A regular match based on pattern and, if matched to, returns a matching result, such as a match that does not return a null
Search : A regular match based on pattern, or the number of indexes if i
{Get the data closest to the first comma, i.e. Substring_index (Substring_index (a.msize, ', ', b.id), ', ',-1)i = i +1}id = ID +1}Summarize:The disadvantage of this approach is that we need a separate table with sequential numbers (here is incre_table). and the maximum value of a continuous series must be greater than the number of values that match the split.For example, if a row of msize has 100 comma-separated values, then our incre_table needs to have at least 100 contiguous rows.Of course
request we do not need to write so many parameters.Example 8:Copy CodeThe code is as follows:function f2c (s) {var test =/(\d+ (\.\d*)?) f\b/g; Description Fahrenheit temperature Possible mode: 123F or 123.4FReturn (S.replace(Test,function (strobj,$1) {Return ((($1-32) *) + "C");}));}document.write (F2C ("water:32.2f and oil:20.30f.");Output: water:0.10000000000000142c and oil: -5.85c.More applications:Exa
JS regular function match, exec, test, search, replace, split use the introduction set1.match MethodUse the regular expression pattern to perform a lookup on a string and return the result that contains the lookup as an array.Stringobj.match (RGEXP)ParametersStringobjRequired option. A string object or string literal on which to find.RgexpRequired option. is a regular expression object that contains the reg
A field in the database is spliced with commas (,). Each field is the primary key of another table. You need to query the child element or delete the element for the field spliced with commas, there will be more complex string parsing.
Therefore, the split method provided by string is tested first.
As you can see, all the commas before the element are considered as delimiters and are split into a string a
The original Http://www.jb51.net/article/28007.htm JS regular function match, exec, test, search, replace, split use the introduction set, learning regular expression of friends can refer to.
Match Method Use the regular expression pattern to perform a lookup on a string and return the result that contains the lookup as an array. Stringobj.match (rgexp) parameterStringobj required option. A string object o
call exec to iterate through all the matches, equivalent to match with the G flag.
Of course, if the regular expression forgets to use G, and then uses the loop (for example: while, for, etc.), Exec loops the first one each time, causing a dead loop.
EXEC's output will contain child matches.
Example 3:
Copy Code code as follows:
function Execdemo () {
var r, re; Declare a variable.
var s = "The rain in Spain falls mainly in the plain";
Re =/[\w]* (AI) n/ig;
R = re.exec (
replace XXF with XXC, and on request we do not need to write so many parameters.Example 8:Copy the code code as follows:function f2c (s) {var test =/(\d+ (\.\d*)?) f\b/g; Description Fahrenheit temperature Possible mode: 123F or 123.4FReturn (S.replace(Test,function (strobj,$1) {Return ((($1-32) *) + "C");}));}document.write (F2C ("water:32.2f and oil:20.30f.");Output: water:0.10000000000000142c and oil: -
at the code first:var stomatch = "Test, Tes, TST, Tset, test, Tesyt, sTes";var reEs =/es/gi;Alert (Rees.exec (Stomatch));Alert (Stomatch.match (reEs));Alert (Stomatch.search (reEs));The contents of the three popup boxes are as follows:The results are analyzed as follows:1, regexp the Exec () method, has a string parameter, returns an array, the first entry of the array is the first match, the other is a re
request we do not need to write so many parameters.Example 8:Copy CodeThe code is as follows:function f2c (s) {var test =/(\d+ (\.\d*)?) f\b/g; Description Fahrenheit temperature Possible mode: 123F or 123.4FReturn (S.replace(Test,function (strobj,$1) {Return ((($1-32) *) + "C");}));}document.write (F2C ("water:32.2f and oil:20.30f.");Output: water:0.10000000000000142c and oil: -5.85c.More applications:Exa
Split + a website with IP address tracking and query ~ Help test the split + IP tracking and query website ~ For more information, see IPhttp: // myip.many3.com/trackingip?http://ip.many3.com/find the bugand submit your suggestion ~ Thank you! P. split + a website with IP tracking and query ~ Help
not match regular characters The above function parameters we all used it. In practice, we only have to replace the XXF with the XXC, according to the requirements, we do not need to write so many parameters. Example 8: Copy code code as follows: function f2c (s) { var test =/(d+ (. d*)?) fb/g; The possible modes of Fahrenheit temperature are: 123F or 123.4F return (s.replace (test, Function (strobj
Test: tests Whether a string contains a matching result, contains a return of true, and does not contain a return of false. match: Regular match based on pattern, if matched to, returns match result, such as no match to return null Search : a regular match based on pattern, and returns the number of indexes if it matches a result; 1 Split: Regular segmentation According to pattern, returns a segmented ar
Exec: Regular Expression is performed on the string, and the matching result is returned. array [0] is the original string, and array [I] is the position that matches the entire string to be searched.
Test: test whether a string contains a matching result. If the string contains a matching result, true is returned. If the string does not contain a matching result, false is returned.
Match (pattern): regular
ReplaceText can also be a function return value that returns a string: Returns the replacement string Example 1:varstr ="AAABBBCCCAAABBBCCC"; varReg =/aaa/; varres = str.replace (Reg, ' 111); Console.log (res);//return 111BBBCCCAAABBBCCC, replace only the first match, if you need to replace all you need to use the G option5. Split function Prototype: Stringobj.split ([separator[, limit]]) Parameter: separator represents a delimiter (this can also be
|jpg|jpeg|png|bmp|swf|flv|ico) $ {Expires 30d;Access_log off;}Location ~. *\. (JS|CSS)? $ {Expires 7d;Access_log off;}}Server{Listen 80;server_name xiaoz.me www.xiaoz.me;Rewrite ^ (. *) https://www.xiaoz.me$1 permanent;}
HTTPS Run split test
We can open SSL Labs test our website HTTPS run points, if you have upgraded to OpenSSL 1.0.2 and opened the HTTP/
EXEC: Regular processing of string and return of matching result. Array[0] is the original string, Array[i] to match the position in the entire searched string.
Test: Tests whether string contains a matching result, contains return true, and does not contain return false.
Match (pattern): a regular match based on pattern and, if matched to, returns a matching result, such as a match that does not return null
Search (Pattern): a regular match based on
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.