Oracle OWA_MATCH
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose for use with the Oracle Web Agent
AUTHID DEFINER
Data Types empty_vc_arr owa_util.vc_arr;
Dependencies
OWA_PATTERN OWA_UTIL PLITBLM
Documented No
First Available 2004
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/pubmat.sql
{ORACLE_HOME}/rdbms/admin/privmat.sql
 
MATCH_PATTERN
Pattern matches against owa_match.match_pattern(
p_string            IN VARCHAR2,
p_simple_pattern    IN owa_util.vc_arr DEFAULT empty_vc_arr,
p_complex_pattern   IN owa_util.vc_arr DEFAULT empty_vc_arr,
p_use_special_chars IN BOOLEAN DEFAULT TRUE)
RETURN BOOLEAN;
DECLARE
 sPattern owa_util.vc_arr;
 cPattern owa_util.vc_arr;
BEGIN
  sPattern(1) := 'sys.%';
  sPattern(2) := 'dbms\_%';
  sPattern(3) := 'utl\_%';
  sPattern(4) := 'owa\_%';
  sPattern(5) := 'owa.%';
  sPattern(6) := 'htp.%';
  sPattern(7) := 'htf.%';

  IF ((owa_match.match_pattern('test', sPattern, cPattern, TRUE))) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;

  IF ((owa_match.match_pattern('sys.%', sPattern, cPattern, TRUE))) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F
T

Related Topics
Built-in Functions
Built-in Packages
OWA_PATTERN
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx