Skip to content

Tag Archives: SQL-PL/SQL

The objective is to use the function RAWTOHEX in PL/SQL code. Purpose : This inbuilt function is beneficial for the conversion of a raw value… Read More
Prerequisite – PL/SQL Introduction, Decision Making in PL/SQL Write a pl/sql program to input two dates and print number of Sundays between those two dates.… Read More
The FLOOR is an inbuilt function in PLSQL which is used to return the largest integer value which will be either equal to or less… Read More
The CEIL is an inbuilt function in PLSQL which is used to return the smallest integer value which is either greater than or equal to… Read More
The EXP is an inbuilt function in PLSQL which is used to return a value which is e raised to the nth power. Here “e”… Read More
The LN function is an inbuilt function in PLSQL which is used to return the natural logarithm of a given input number. The natural logarithm… Read More
The TRUNC function is an inbuilt function in PLSQL which is used to return a number truncated to a particular number of decimal places. Syntax:… Read More
The PLSQL SIN function is used to return the sine of a numeric value. The SIN function accepts one parameter which is the number whose… Read More
The PLSQL DBTIMEZONE function is used for returning the database time zone value. The PLSQL DBTIMEZONE function does not require any parameter to be passed.… Read More
The PLSQL LAST_DAY function is used for returning the last day of the month based on a date value. The last day of the month… Read More
The PLSQL EXTRACT function is used for extracting a specific value such as year, month, day or hour from a date or an interval value.… Read More
The PLSQL COS function is used to return the cosine of a numeric value. The COS function accepts one parameter which is the number whose… Read More
The PLSQL ATAN2 function is used to return the arc tangent of n and m. The ATAN2 function is generally used if you want to… Read More
The PLSQL LOG function is used for returning the logarithm of n base m. The LOG function accepts two parameters which are used to calculate… Read More
The PLSQL COSH function is used to return the hyperbolic cosine of a numeric value. The COSH function accepts one parameter which is the number… Read More