Tag: SQL
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...
In this material I will show you how to compare two databases in Microsoft SQL Server with the possibility of further synchronization, while showing a simple way that does not require writing complex...
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...
IT departments work with a meager budget. Therefore, cost-cutting will allow the company not only to stay afloat, but also to direct the saved money to development.To use the available budget...
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...