SQL Developer

You can execute a stored procedure in SQL Developer in two ways. Below are the examples: 1. Execute Stored Procedure Using Run PL/SQL in SQL Developer Open SQL Developer and connect to the Oracle Database. Then left side in Connections […] More

In this tutorial, I am giving a step-by-step example to create a schema in Oracle using SQL Developer. The method described below applies to all the versions of Oracle database like 10g, 11g, 12c, etc. In Oracle, a schema is […] More

Oracle SQLcl (Oracle SQL Developer Command Line) is a command line tool for Oracle Database. SQLcl has some nice features in comparison to SQL*PLUS such as in-line editing, statement completion, command recall, etc. Also, you can run your SQL*PLUS scripts with […] More

Below is the step by step guide to how to schedule a job in Oracle SQL Developer. Steps to Schedule a Job in Oracle SQL Developer In the following example, we will create a job to run every night at […] More

In this tutorial, I am giving an example to export query result to an Excel file in Oracle SQL Developer. The following are the steps: Export SQL Query Result to Excel File in Oracle SQL Developer Open Oracle SQL Developer […] More

If you want to check tablespace in Oracle SQL Developer, then you must have the DBA privilege. You can use the SYS and System user to view the tablespaces information or grant the DBA privilege to any user from SYS user, […] More

In Oracle SQL Developer, if you will try to import an XML file using the Import menu option, then you will not find a choice to import as XML. There are only three options exists in Oracle SQL Developer even […] More

You have executed a query in Oracle SQL Developer, and now you want to view the execution time for that SQL query. Below is a tip to how to find query execution time in Oracle SQL Developer. Find Query Execution […] More