SQL Server Blog
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,...
It is very important for a professional developer (programmer) to be able to work effectively in the SQL*Plus environment. It is important to be able to perform competent configuration and...
PostgreSQL extract function extracts parts from the date. Syntax of the extract function in PostgreSQL extract( unit from date ) Parameters and function argumentsdate - date, timestamp,...
PostgreSQL date_part function extracts parts from the date. The syntax of the date_part function in PostgreSQL date_part( 'unit', date ) Parameters and function argumentsdate - Date,...
PostgreSQL current_timestamp function returns the current date and time with the time zone. Syntax of the current_timestamp function in PostgreSQL current_timestamp( [ precision ] ) Parameters...
The current_time function in PostgreSQL returns the current time with the time zone. Syntax of the current_time function in PostgreSQL current_time( [ precision ] ) Parameters and function...
The current_date function in PostgreSQL returns the current date. Syntax of current_date function in PostgreSQL current_date Parameters and function argumentsThere are no parameters or...