You can test or manipulate strings using the built-in functions REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR. Oracle's regular expression features use characters like '.', '*', '^', and '$' that you might be familiar with from UNIX or Perl programming. For multi-language programming, there are also extensions such as '[:lower:]' to match a lowercase letter, instead of '[a-z]' which does not match lowercase accented letters.

Regular expressions are a way of describing a pattern - for example, "all the words that begin with the letter A" or "every 10-digit phone number" or even "Every sentence with two commas in it, and no capital letter Q". Regular expressions (aka "regex"s) are useful in Apache because they let you apply certain attributes against collections of files or resources in very flexible ways - for example, all .gif and .jpg files under any "images" directory could be written as /\/images\/.*(jpg|gif)$/. See similar questions...

When you imbed an INSERT, UPDATE, DELETE, or SELECT SQL statement directly in your PL/SQL code, PL/SQL turns the variables in the WHERE and VALUES clauses into bind variables automatically. Oracle can reuse these SQL statement each time the same code is executed. To run similar statements with different variable values, you can save parsing overhead by calling a stored procedure that accepts parameters, then issues the statements with the parameters substituted in the right places. See similar questions...

Starting from Oracle8i one can use the "EXECUTE IMMEDIATE" statement to execute dynamic SQL and PL/SQL statements (statements created at run-time). Look at these examples. Note that the statements within quotes are NOT semicolon terminated: EXECUTE IMMEDIATE 'CREATE TABLE x (a NUMBER)'; -- Using bind variables... sql_stmt := 'INSERT INTO dept VALUES (:1, :2, :3)'; EXECUTE IMMEDIATE sql_stmt USING dept_id, dept_name, location; -- Returning a cursor.. See similar questions...

Perl is supplied with extensive documentation. Enter perldoc perlre at a shell or DOS prompt to display the section covering Perl Regular Expressions. HTML versions are available at many locations including this version of Perl Regular Expressions. See similar questions...

Yes. New in v1.1.5, DenyHosts adds the ability for the user to specify additional regular expressions that can be used to locate possible break-in attempts. The USERDEF_FAILED_ENTRY_REGEX can be specified repeatedly. Each value must contain a single regular expression that includes a host regular expression group and optionally a user group. It is assumed that the end user is familiar with regular expressions in order to take advantage of this feature. See similar questions...

Latest Answer: Hi All,I am new to this community. It seems the question is related to Begin End block of PL/SQL. Se... Latest Answer: You must be speaking about PLS_INTEGER. PLS_INTEGER, uses machine-arithmetic unlike BINARY_INTEGER... Latest Answer: DESC will display the values in DESCending order when used in an ORDER BY clause.For example:SELECT ... Latest Answer: In hash join hash table gets build using the inputs. Nested loops as the name implies uses looping c.. See similar questions...

By default, you put an exception handler at the end of a subprogram to handle exceptions that are raised anywhere inside the subprogram. To continue executing from the spot where an exception happens, enclose the code that might raise an exception inside another BEGIN-END block with its own exception handler. For example, you might put separate BEGIN-END blocks around groups of SQL statements that might raise NO_DATA_FOUND, or around arithmetic operations that might raise DIVIDE_BY_ZERO. See similar questions...

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements. PL/SQL is a normal programming language that includes all the features of most other programming languages. See similar questions...

The or operator is '\|', not '|', and the grouping operators are '\(' and '\)'. Also, the string syntax for a backslash is '\\'. To specify a regular expression like 'xxx\(foo\|bar\)' in a Lisp string, use 'xxx\\(foo\\|bar\\)'. Unlike in Unix grep, sed, etc., a complement character set ('[^...]') can match a newline character (<LFD> a.k.a. C-j a.k.a. '\n'), unless newline is mentioned as one of the characters not to match. The character syntax regexps (e.g. See similar questions...

Both PL/SQL and Java can be used to create Oracle stored procedures and triggers. This often leads to questions like "Which of the two is the best?" and "Will Oracle ever desupport PL/SQL in favour of Java?". Many Oracle applications are based on PL/SQL and it would be difficult of Oracle to ever desupport PL/SQL. In fact, all indications are that PL/SQL still has a bright future ahead of it. Many enhancements are still being made to PL/SQL. See similar questions...

No. Regular expressions were an option, but both the search time due to server overhead and the steep learning curve for the average user have made us decide to drop the idea. However, you will find that the equal sign option offers ample power and flexibility to your search. See similar questions...

What is the easiest way to execute a template, but write the output to a file, to be used as static HTML. The Tea Template Language document has a section titled "Java Integration". The SimpleTea example shows how to integrate with the Tea compiler and runtime. This example outputs to a String, but it can easily be adapted to write to files. See similar questions...

Very powerful addition to the Find command. I used: Caption=[A-Z]\w+ to find all lines with Caption followed by = and a Capital Letter, followed by any letters and a space. Then F3 gave me the next. Learn them! There is an explanation of how to use Regular Expressions here. See similar questions...

There are many regular expression engines. ORF uses PCRE engine (Perl-Compatible Regular Expressions), which implements (almost) the same syntax and semantics as Perl 5 (see http://www.pcre.org and http://www.pcre.org/pcre.txt [warning! large file] for documentation). Note that it is not the same engine used by Perl, Java or the .NET Framework. See similar questions...

With Mailfilter you can define your own filter rules to determine which e-mails are considered waste and what should be downloaded into your local computer. Such rules are defined by using Regular Expressions. It is very common for these kinds of programs to employ this technique because of its great flexibility. See similar questions...

NSP actually checks each regular expression one by one. Unfortunately if the list of regex's is very long, this becomes too slow computationally, and so instead we actually concatenate all the regular expressions to form one big regex, which is then used to do the matching. For example given the regexes above, they will be combined into a single regex, like so: and then this regex is used to do the matching. See similar questions...