ABS function in Oracle SQL

ABS function in Oracle SQL returns the absolute value. Let’s assume a number -10 when you run the abs function of this number it returns 10 which is an absolute value. This function also works on the decimal. Syntax ABS(N) N – input parameter SELECT ABS(-10)FROM DUAL; Absolute ———- 10

SQL Developer download

SQL Developer is a free tool by Oracle which helps you to connect Oracle database, query, run scripts, and administer the database. It is a complete IDE for PL/SQL applications developers. You can also use SQL developer to connect MS SQL Server, SYBASE, MySQL Database using third part JDBC database drivers. Oracle provides most of …

SQL Developer download Read More »

How to use DBMS_UTILITY.GET_TIME in Oracle Database

DBMS_UTILITY.GET_TIME is a function available in Oracle Database to get time in millisecond. You need to divide it by 100 to get time in seconds. Below is the syntax, DBMS_UTILITY.GET_TIME RETURN NUMBER; The return type is number and in some cases, it is negative as well. DBMS_UTILITY.GET_TIME Examples Now, let’s understand the working of dbms_utility.get_time …

How to use DBMS_UTILITY.GET_TIME in Oracle Database Read More »