what is – Page 100

REGEXP_SUBSTR() Function in Oracle

August 5, 2021 by Ian

In Oracle, the REGEXP_SUBSTR() function returns a substring from a string, based on a regular expression pattern.

It extends the functionality of the SUBSTR() function by allowing us to use regular expression patterns.

REGEXP_REPLACE() Function in Oracle

August 4, 2021 by Ian

In Oracle, the REGEXP_REPLACE() function replaces occurrences of the substring within a string that matches the given regular expression pattern.

It extends the functionality of the REPLACE() function by allowing us to use regular expression patterns.

REGEXP_INSTR() Function in Oracle

August 6, 2021August 4, 2021 by Ian

In Oracle, the REGEXP_INSTR() function searches a string for a regular expression pattern. It returns an integer indicating the beginning or ending position of the matched substring (whichever one you specify).

It extends the functionality of the INSTR() function by allowing us to use regular expression patterns.

NLS_LOWER() Function in Oracle

August 3, 2021 by Ian

In Oracle, the NLS_LOWER() function returns its argument with all letters in lowercase.

It’s similar to the LOWER() function, except that it accepts a second argument that allows you to specify the collation. The collation handles special linguistic requirements for case conversions.

NLS_UPPER() Function in Oracle

August 3, 2021 by Ian

In Oracle, the NLS_UPPER() function returns its argument with all letters in uppercase.

It’s similar to the UPPER() function, except that it accepts a second argument that allows you to specify the collation. The collation handles special linguistic requirements for case conversions.

RPAD() Function in Oracle

August 2, 2021 by Ian

In Oracle, the RPAD() function allows you to pad the right part of a string with a certain character, to a specified number of characters.

The way it works is, you specify how long the resulting string should be. If the original string is shorter, the padding character fills in the remaining space.

LPAD() Function in Oracle

August 2, 2021 by Ian

In Oracle, the LPAD() function allows you to pad the left part of a string with a certain character, to a specified number of characters.

The way it works is, you specify how long the resulting string should be. If the original string is shorter, the padding character fills in the remaining space.

MariaDB FIELD() vs FIND_IN_SET(): What’s the Difference?

August 1, 2021 by Ian

Two similar functions in MariaDB are FIELD() and FIND_IN_SET(). At first glance, these appear to do the same thing, but there is a difference.

This article looks at the difference between these two functions.

TRANSLATE() Function in Oracle

August 1, 2021 by Ian

In Oracle, the TRANSLATE() function allows you to make several single-character, one-to-one substitutions in one operation.

It returns the string provided as a first argument after some characters specified in the second argument are translated into a destination set of characters specified in the third argument.

It’s similar to the REPLACE() function, except that the REPLACE() function replaces the whole string with another string (i.e. not character by character, like TRANSLATE() does).

NLSSORT() Function in Oracle

August 1, 2021 by Ian

In Oracle, the NLSSORT() function returns a collation key for a given character value and an explicitly or implicitly specified collation.

The function can be useful for performing comparisons against string values based on a specified collation.