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 pane, expand the schema node in which you want to execute the stored procedure. Then ... Read 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 a user having database objects, and a user is just a user who is having ... Read 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 it. In this tutorial, I am giving a step by step guide to how to ... Read 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 11:00 PM to execute an Oracle stored procedure BATCH_PROCESS_AT_NIGHT. In Oracle SQL Developer after connecting to ... Read 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 and connect to the database. Then press Alt+F10 key to open an SQL Worksheet. In ... Read 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, the below is an example: Grant DBA to SCOTT; Check Tablespaces in Oracle SQL Developer ... Read 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 in the latest version 18.2, and they are CSV, Delimited and the Text format. So ... Read 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 Time in Oracle SQL Developer Before running the query in Oracle SQL Developer, open the ... Read more