Refer to:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/misc/sql_pattern/sql_pattern.html
Chapter 18 SQL for Pattern Matching
Both provide comprehensive examples to this feature.
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/misc/sql_pattern/sql_pattern.html
Chapter 18 SQL for Pattern Matching
Both provide comprehensive examples to this feature.