Database

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

Generating Excel output from PL/SQL is a common requirement. But, there is no built-in function/API in Oracle Database which you can use to generate it. In this article, I will show how to get excel from PL SQL using dbms_output.put_line, utl_file available in Oracle. Note:- The file generated using some of these methods is not

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 is a tool by Oracle to develop and manage Oracle Database. You can also connect to SQL Server, DB2, MySQL, Sybase, or any third party database using the drivers. You can run queries and scripts, manage the database, migrate 3rd party databases to Oracle. It is a complete end-to-end development tool for PL/SQL

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

SQL Developer provides an easy way to connect Oracle Database. Just start, enter database information like Host, Service, port, and click on connect. But, how to connect to the cloud database? Ports ranging from 1520-1530 are not available on secure Oracle public cloud. You need to connect the oracle database using a secure shell (SSH)

Oracle is a relational database management system by Oracle Corporation. It is one of the most widely used databases in OLTP, Data warehouse. Oracle released a good number of versions since 1979 and the latest version is 19C which is available for on-premise as well as in the cloud. Many of the users are still

SQL Server is a relational database management system by Microsoft Corporation. You need the Microsoft SQL Server Management tool to connect and work with SQL Server. But, you can also use SQL Developer to connect SQL Server using JDBC Driver called jTDS 3rd party JDBC driver. In this article, I will show how to connect

The ORA-00000 normal, successful completion in Oracle means there is no error in SQL Queries or whatever transactions performed are successful. You can simply ignore this message. As per Oracle error message guide, Cause: An operation has completed normally, having met no exceptions. Action: No action required Let’s reproduce ORA-00000, Create an anonyms block as shown below.

The ORA-00001: unique constraint (string.string) violated error comes when you try to update or insert a record in a table(Oracle Database) that creates a duplicate on the columns which are defined as unique. As per Oracle error message guide, ORA-00001: unique constraint (string.string) violatedCause: An UPDATE or INSERT statement attempted to insert a duplicate key. For