Tag: Oracle Database

The Oracle/PLSQL BITAND function returns an integer number representing the bitwise operation AND over the bits expr1 and expr2. Oracle/PLSQL syntax of the BITAND function bitand( expr1_id,...

The Oracle/PLSQL AVG function returns the average value of the expression. Oracle/PLSQL syntax of AVG function SELECT AVG(aggregate_expression_id) FROM tabs [WHERE conds]OR AVG function...

The Oracle/PLSQL ABS function returns the absolute value of a number. Oracle/PLSQL syntax of the ABS function ABS( number_id ) Parameters and function argumentsnumber_id - for...

Symbolic Oracle functionsFunction DescriptionASCII The Oracle/PLSQL ASCII function returns the numeric representation of the leftmost character of the string.ASCIISTR The...

The Oracle/PLSQL VSIZE function returns the length in bytes for the internal representation of the expression. Syntax of the Oracle/PLSQL VSIZE function VSIZE( expression_id ) Parameters and...

The Oracle/PLSQL UPPER function converts all characters of a string into upper case. If there are characters in a string that are not letters, they do not affect this function. Syntax of the...

The Oracle / PLSQL TRIM function removes all specified characters from the beginning or end of a string. Function Oracle / PLSQL TRIM syntax TRIM( [ [ LEADING_id | TRAILING_id | BOTH_id ]...

The Oracle/PLSQL TRANSLATE function replaces the sequence of characters in a string with another character set. However, it replaces one character at a time.For example, it replaces the first...

The Oracle/PLSQL TO_CHAR function converts a number or date into a string. Syntax of the Oracle/PLSQL TO_CHAR function TO_CHAR( value_id, [ format_mask_id ], [ nls_language_id ] ) Parameters...

The Oracle/PLSQL SUBSTR function allows extracting a substring from a string. Syntax of the Oracle/PLSQL SUBSTR function SUBSTR( string_id, start_position_id, [ length_id ] )  Parameters and...

` Parameters and function argumentsstring1_id - string whose phonetic value will be returned.The return value of the SOUNDEX function will always start with the first letter...

The Oracle/PLSQL RTRIM function removes all specified characters from the right side of the string. Syntax of the Oracle/PLSQL RTRIM function RTRIM( string1_id, [ trim_string_id ] ) Parameters...

The Oracle/PLSQL RPAD function supplements a certain character set from the right side of the string (at non-zero string1). Syntax of the Oracle/PLSQL RPAD function RPAD( string1_id,...

The Oracle/PLSQL REPLACE function replaces a sequence of characters in a string with another character set. Oracle/PLSQL REPLACE function syntax REPLACE( string1_id, string_to_replace_id, [...

The Oracle/PLSQL REGEXP_SUBSTR function is an extension of function SUBSTR. This function, represented in Oracle 10g, allows you to extract substring from a string using regular expression...

The Oracle/PLSQL REGEXP_REPLACE function is an extension of the function REPLACE. This function, introduced in Oracle 10g, allows you to replace a sequence of characters in a string with a...