1,REGEXP_LIKE : And LIKE The functions of are similar 
2,REGEXP_INSTR : And INSTR The functions of are similar
3,REGEXP_SUBSTR : And SUBSTR The functions of are similar
4,REGEXP_REPLACE : And REPLACE The functions of are similar
They are similar in usage to Oracle SQL function LIKE、INSTR、SUBSTR and REPLACE The usage is the same ,
But they use POSIX Regular expressions replace the old percent sign (%) And wildcards (_) character .
POSIX Regular expressions consist of standard metacharacters (metacharacters) What constitutes a :
'^' Matches the start of the input string , Use... In a square bracket expression , In this case, it means that the character set is not accepted .
'$' Matches the end of the input string . If set RegExp Object's Multiline attribute , be $ Yepi
with '/n' or '/r'.
'.' Matches any single character except the newline character .
'?' Match previous subexpression zero or once .
'+' Match previous subexpression one or more times .
'*' Match previous subexpression zero or more times .
'|' Indicate a choice between the two . Example '^([a-z]+|[0-9]+)$' Represents a combination of all lowercase letters or numbers
character string .
'( )' Mark the beginning and end of a subexpression .
'[]' Mark a bracket expression .
'{m,n}' A precise range of occurrences ,m=< Number of occurrences <=n,'{m}' Appear m Time ,'{m,}' At least
appear m Time .
/num matching num, among num Is a positive integer . Reference to the match obtained .
Character cluster : 
[[:alpha:]] Any letter .
[[:digit:]] Any number .
[[:alnum:]] Any letters and numbers .
[[:space:]] Any white character .
[[:upper:]] Any capital letter .
[[:lower:]] Any lowercase letter .
[[:punct:]] Any punctuation .
[[:xdigit:]] whatever 16 Decimal digit , amount to [0-9a-fA-F].
Operation priority of various operators
/ Escape character
(), (?:), (?=), [] Parentheses and brackets
*, +, ?, {n}, {n,}, {n,m} qualifiers
^, $, anymetacharacter Location and order Usage method :
select dabh from qtywb where regexp_like(dabh, '[[:alpha:]]');

oracle Query data with letters in [ Regular expressions ] More articles about

  1. Oracle Query all the table spaces and corresponding data files in the current database

    Oracle Query all the table spaces and corresponding data files in the current database ------------------------------------------------------------------ ...

  2. About Oracle The display format of the number value in the query needs to retain two decimal places ( Or three , And other digits )

    About Oracle The display format of the number value in the query needs to retain two decimal places ( Or three , And its ... Method 1 : Use to_char Of fm Format , namely : to_char(round(data.amount,2),'FM9999 ...

  3. Oracle Use cursor to get the string corresponding to all field names of the specified data table

    Operation steps : open PLSQL Developer after , Just execute the following statement --Oracle Use cursor to get the string corresponding to all field names of the specified data table declare mytablename VARCHAR( ...

  4. oracle Query which tables are referenced by a table in

    cause : When testing the system, it is found that if a record has been referenced , Deleting this record at this time will cause data inconsistency , The system will report an error . Like police information , Police officers will be quoted in the attendance record ID, If the police officer already exists in the attendance record ID 了 , From the police list ...

  5. ORACLE The execution sequence of the query statement in where Partial condition execution sequence test

    Oracle Some query statements and their execution order in Original address :https://www.cnblogs.com/likeju/p/5039115.html Query criteria : 1)LIKE: Fuzzy query , You need to use two wildcards , ...

  6. oracle Query the current system time used in dual What is it? ?

    oracle When we query the current system time , Frequently used dual, What is this ? -- Query system time result :2018/04/17 15:00:48 -- select sysdate from dual; ...

  7. Oracle In this paper, the index of the query is introduced

    1. There is no qualification for the returned line , That is, no where Clause 2. There is no row qualification for the data table corresponding to any index primary column, for example : stay City-State-Zip Column creates a three column composite index , So just for State Column qualifiers cannot use this index ...

  8. Oracle Summary of methods for querying various objects in

    -- View all the tables in the current library select * from all_tables a where a.table_name='INFOCODE_P20081'-- View table structure select * from all_ ...

  9. How to be in Oracle in Query a table referenced by other database objects [z]

    The boss asked me to oracle Find out where the table to be replaced is referenced by other objects , Make a list , Received the task , I'm a fool in the face , How to find ? Looking for a needle in a haystack ? Ask colleagues . Check information , Self study , Finally, it is just for your reference , In the meantime, for future review . Ben ...

Random recommendation

  1. RobotFramework - Basic introduction

    Robot Framework Wiki HomePage Robot Framework User Guide Robot Framework documentation Robot Framewo ...

  2. Oracle Common operations

    Modify database table name :rename [old-table] to [new-table]; while Loop add test data : declare     i int:=1;     begin     while ...

  3. ArcGIS Engine Geometric objects and WKB Transformation

    using System; using System.Collections.Generic; using System.Text; using GisSharpBlog.NetTopologySui ...

  4. Quartz.NET To configure (Log4net)

    Recently there was a task about service scheduling , I remember seeing it before Quartz.NET Scheduling is great . Today's test Quartz.NET, Front configuration Quartz.NET It's easy , The console also outputs . But I want to cooperate with Log4net To make log files , Yes? ...

  5. warning : json_decode(): option JSON_BIGINT_AS_STRING not implemented in xxx

    Let's start with json_decode Official statement mixed json_decode ( string $json [, bool $assoc = false [, int $depth = 512 [, i ...

  6. mock Tested powermock

    Because the corporate framework relies on other modules , As a result, our development always needs to follow in their footsteps , So my superior leaders put forward this plan and said to skip them directly , We test it locally ourselves , And then I found it , The import related jar <dependency> ...

  7. SQL Development ——SQL grammar

    Documentation reference : Reference resources :http://www.w3school.com.cn/sql/sql_syntax.asp Reference resources :http://wiki.jikexueyuan.com/project/sql/ ...

  8. Operation, maintenance and automation series ③ Automated Deployment foundation and shell Script implementation

    Automated Deployment foundation and shell Script implementation The basics of Automation : 1.1: The implementation of the current code deployment : Operation and maintenance is purely manual scp To web The server logs in manually git Server execution git pull or svn Server execution svn upda ...

  9. Flink &ndash; Stream Task Execution process

    Task.run if (invokable instanceof StatefulTask) { StatefulTask op = (StatefulTask) invokable; op.set ...

  10. ( turn )Memcache Memory allocation policy

    from :http://hi.baidu.com/software_one/item/0a0a6712dc7a319899ce33e0 One .Memcache Memory allocation mechanism There are many explanations on the Internet about this mechanism , Me ...