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… Read More »ABS function in Oracle SQL

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.… Read More »3 Ways to generate Excel output using Oracle PL SQL

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… Read More »SQL Developer download

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… Read More »How to Install SQL Developer on Windows 10

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.… Read More »DBMS_UTILITY.GET_TIME in Oracle Database

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… Read More »Connect to Oracle Cloud Database from SQL Developer

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… Read More »How to Check Oracle Database Version?

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… Read More »How to Connect to SQL Server from SQL Developer

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… Read More »ORA-00000 normal, successful completion

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… Read More »ORA-00001: unique constraint (string.string) violated