Skip to content

Tag Archives: DBMS-SQL

OCT() function in MySQL is used to convert decimal number to octal. It returns equivalent octal value of a decimal number. Syntax : OCT(number) Parameter… Read More
In this article, you will see how you can use the current_date function and you will see both formats in the string and numeric respectively.… Read More
IPmt() Function in MS Access is used to return a double specifying the interest payment for a given period of an annuity based on periodic,… Read More
1. SIN() Function : The SIN() function returns the sine of a number. Syntax : SIN(number) Parameter : Required. A numeric value. number : It… Read More
1. DEGREES() Function : The DEGREES() function converts a value in radians to degrees. Syntax : DEGREES(number) Parameter : Required. A numeric value. number :… Read More
In this article, we are going to cover how we can modify the existing data in SQL. There are lots of situations where we need… Read More
1. FLOOR() Function : The FLOOR() function returns the largest integer value which is less than or equal to a number. Syntax : FLOOR(number) Parameter… Read More
As a DBA, you might need to copy the objects and the content of specific tables from a database to another one in the same… Read More
Introduction to Import-and-Export Wizard : The wizard allows easy steps through a process, and to execute the data copy process with writing very little or… Read More
1. SIN() Function : SIN() function in MySQL is used to return the sine of any given number X, where X is given in radians.… Read More
1. FLOOR() Function : FLOOR() function in MySQL is used to return the largest integer value which will be either equal to or less than… Read More
The LOG() function returns the logarithm of a specified number or the logarithm of the number to the specified base. Syntax : LOG(number, base) Parameter… Read More
In this article, we are going to cover UNICODE() function where you will see the Unicode for given specific character or for expression character. UNICODE()… Read More
This function returns the logarithm of a number to base 10. Syntax : LOG10(number) Parameter : This method accepts a single-parameter as mentioned above and… Read More
In this article, we are going to cover the ATN2()function in which we will see how we can get the arc tangent of two given… Read More

Start Your Coding Journey Now!