Tag: SQL

PostgreSQL length function returns the length of the specified string, expressed in the number of characters. Syntax of the length function in PostgreSQL length( string ) Parameters and...

PostgreSQL upper function converts all characters in the specified string to upper case. Syntax of the upper function in PostgreSQL upper( string ) Parameters and function arguments...

PostgreSQL trim function removes all specified characters from the beginning or end of a line. Syntax of trim function in PostgreSQL trim( [ leading | trailing | both ] [ trim_character ] from...

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

PostgreSQL substring function allows extracting substring from a string. Syntax of the substring function in PostgreSQL substring( string [from start_position] [for length] ) Parameters and...

The PostgreSQL replace function replaces all occurrences of the specified string. Syntax of the replace function in PostgreSQL replace( string, from_substring, to_substring ) Parameters and...

The PostgreSQL position function returns the substring location in a string. Syntax of the position function in PostgreSQL position ( substring in string ) Parameters and function...

PostgreSQL operator || allows combining 2 or more lines together. Syntax for || in PostgreSQL string1 || string2 || string_n Operator parameters and argumentsstring1 - The first line to...

Immediately after the creation of users in the database, the need to manage their access to various data objects arises. For example, an employee of the human resources department of an...

The PostgreSQL LTRIM function removes all specified characters on the left side of the line. Syntax of LTRIM function in PostgreSQL ltrim( string, trim_character ) Parameters and function...

The PostgreSQL lower function converts all characters of a specified string into a lower case. Syntax of lower function in PostgreSQL lower( string ) Parameters and function arguments...

The character_length function in PostgreSQL returns the length of the specified string. The syntax of the character_length function in PostgreSQL character_length( string ) Parameters and...

The char_length function in PostgreSQL returns the length of the specified string. Syntax of char_length function in PostgreSQL char_length( string ) Parameters and function arguments...

The PostgreSQL now function returns the current time and date with the time zone. Syntax of the now function in PostgreSQL now ( ) Parameters and function argumentsThere are no...

The localtimestamp PostgreSQL function returns the current date and time. Syntax of the PostgreSQL localtimestamp function localtimestamp( [ precision ] ) Parameters and function arguments...

There are many ways to connect and work with Oracle databases, but most often the interface and SQL*Plus command set offered in Oracle are used for this purpose. The SQL*Plus interface, in fact,...