Search results
Learn how to use various Oracle string functions to manipulate character strings. See examples of functions such as SUBSTR, REGEXP_SUBSTR, LPAD, RPAD, and more.
- Substr
Learn how to use the Oracle SUBSTR() function to extract a...
- LPAD
The Oracle LPAD() function returns a string left-padded with...
- Replace
The Oracle REPLACE() function replaces all occurrences of a...
- Soundex
Oracle SOUNDEX() function examples. Let’s take some examples...
- Regexp Instr
REGEXP_INSTR( string, pattern, position, occurrence,...
- RPAD
The following statement uses the RPAD() function to output...
- Regexp Like
The Oracle REGEXP_LIKE() function is an advanced version of...
- Ltrim
Oracle LTRIM() function removes from the left-end of a...
- Substr
String functions perform various character manipulations. They operate on character strings.
17 sie 2021 · Learn about the built-in string/character functions that are available in Oracle Database, such as CONCAT(), INSTR(), LOWER(), and more. See the function description, syntax, and examples for each function.
Learn how to use SQL functions to manipulate data items and return results in Oracle Database Lite. Find the syntax, purpose, arguments, examples, and ODBC functionality of various SQL functions, such as number, character, date, conversion, and aggregate functions.
Learn how to use functions to manipulate data items and return a result in Oracle Database SQL. Find out the types, formats, and examples of functions for numeric, character, datetime, collection, hierarchical, data mining, XML, JSON, and more.
The list of Oracle/PLSQL functions is sorted into the type of function based on categories such as string/character, conversion, advanced, numeric/mathematical, and date/time. These functions can be used in SQL statements or queries in Oracle.
Learn how to use the Oracle SUBSTR() function to extract a substring from a string with various flexible options. See the syntax, arguments, return value, and examples of the SUBSTR() function in SQL.
