SQLS*Plus

Configuring SQL*Plus environment for Oracle application developer

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

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

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

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...

PostgreSQL current_time function

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...

PostgreSQL current_date 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...

PostgreSQL function age

The PostgreSQL function age returns the number of years, months, and days between two dates. Syntax of the function age in PostgreSQL age( [date1,] date2 ) Parameters and function...

PostgreSQL Alias

PostgreSQL Alias can be used to create a temporary name for tables or columns. Column aliases are used to make it easier to read column headers in a set of results.Table aliases are used to...

PostgreSQL comments

Can you place comments in your SQL statements in PostgreSQL? These comments can appear in one line or cover several lines. Let's see how to do that.There are two syntaxes that you can use to...

PostgreSQL variables

In this tutorial, you will learn how to declare variables in PostgreSQL using syntax and examples. What is a variable in PostgreSQL? In PostgreSQL, a variable allows a programmer to temporarily...

PostgreSQL tutorial: PostgreSQL data types

Below is a list of data types available in PostgreSQL, which includes string, numeric, and date/time type. String data types Below are String data types in PostgreSQL :Syntax of data...

MySQL DISTINCT statement

MySQL DISTINCT statement is used to remove duplicates from the result set. The DISTINCT operator may be used only with SELECT operators. Syntax DISTINCT operator in MySQL SELECT DISTINCT FROM...

MySQL FROM statement

MySQL FROM statement is used to display tables and any associations required for querying in MySQL. Syntax of FROM statement in MySQL FROM table1 [ { INNER JOIN | LEFT [OUTER] JOIN | RIGHT...

MySQL SELECT LIMIT statement

MySQL statement SELECT LIMIT is used to extract records from one or more tables into MySQL and limit the number of records to be returned based on the limit value. Syntax of SELECT LIMIT in...

MySQL SELECT statement

MySQL statement SELECT is used to extract records from one or more tables to MySQL. Simple syntax for SELECT statement in MySQL SELECT expressions FROM tables [WHERE conditions]; The full...

MySQL – show user grants

In MySQL, you can use the SHOW GRANTS statement to display all grant information for the user. This will display the privileges that have been assigned to the user with the GRANT command. Syntax...

Tag: SQL