how to run stored proc in oracle sql developer tool

To create a Subversion repository, perform the following steps:

In the Files navigator, navigate to the directory where you unzipped the files from the Prerequisites and open the file PROC_EMP_CURSOR.sql. To view the files to be versioned, perform the following steps: You can view the files stored in your local file system by using the Files navigator. The SQL Worksheet allows you to execute SQL against the connection you When a connection is created, a SQL Worksheet is opened automatically. Once the connection is saved, you will see the database in the list. Note: If this tab is not visible, select View >Ĭheck for the status of the connection on the left-bottom side (above In the Connections tab, right-click Connections Note: If you already have a database connection, you need not perform theįollowing steps, you can move straight to Viewing

Download and unzip the sqldev.zip file that contains all the files you need to perform this tutorial.Login to SQL*Plus as the SYS user and execute the following command:Īlter user hr identified by hr account unlock Install the Oracle Database 10g and later.Install Oracle SQL Developer 2.1 early adopter from OTN here.Prerequisitesīefore starting this tutorial, you should: To import files into your source control system, check them out, modifyĪnd commit the changes back. You can use the version control feature of SQL Developer YouĬan create basic XML extensions or more involved Java extensions to add utilities Is built on an extensible framework and, as such, is extensible itself. Increasing numbers of developers using alternative platforms. Using Oracle SQL Developer, you can browse database objects, run SQL statements,Įdit and debug PL/SQL statements and run reports, whether provided or created. Tool that enhances productivity and simplifies database development tasks. This tutorial shows how to use the souce code control feature

How to run stored proc in oracle sql developer tool