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
The ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction error comes when you issue alter session enable parallel DML command when some… Read More »ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction
