In the Connections navigator, right-click Connections and select New Connection.Įnter HR_ORCL for the Connection Name (or any other name that identifies your connection), hr for the Username and Password, specify your localhost for the Hostname and enter ORCL for the SID. The first step to managing database objects using Oracle SQL Developer is to create a database connection. Download and unzip the sqldev_mngdb.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: With SQL Developer users can connect to any supported Oracle Database, for all Oracle database editions including Express Edition. Multiple platform support also means that usersĬan install SQL Developer on the Database Server and connect remotely from theirĭesktops, thus avoiding client server network traffic.ĭefault connectivity to the database is through the JDBC Thinĭriver, so no Oracle Home is required. This is a great advantage to the increasing numbers of developers Statements and run reports, whether provided or created.ĭeveloped in Java, SQL Developer runs on Windows, Linux and Users can browse database objects, run SQL statements, edit and debug PL/SQL Productivity and simplifies database development tasks. Oracle SQL Developer is a free graphical tool that enhances This tutorial shows introduces Oracle SQL Developer and shows you
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |