![]() Suggestion: Create a shortcut for the SQL Developer executable file that you install, and always use it to start SQL Developer.īefore you install SQL Developer, look at the remaining sections of this guide to see if you need to know or do anything else first. This version of SQL Developer is separate from any SQL Developer kit that you download and unzip on your own, so do not confuse the two, and do not unzip a kit over the SQL Developer files that are included with Oracle Database. If Oracle Database (Release 11 or later) is also installed, a version of SQL Developer is also included and is accessible through the menu system under Oracle. ![]() If you are using a prerelease (Early Adopter) version of SQL Developer, and if you want to be able to continue to use this prerelease version after installing the official release kit, you must unzip the official release kit into a different directory than the one used for the prerelease version. Section 1.11, "SQL Developer Documentation" Section 1.10, "Uninstalling SQL Developer" Section 1.9, "Using a Screen Reader and Java Access Bridge with SQL Developer" Section 1.8, "Finding SQL Developer Accessibility Information" Section 1.7, "Advanced Security for JDBC Connection to the Database" Section 1.6, "Database Certification for SQL Developer (Oracle and Third-Party)" Section 1.5, "Location of User-Related Information" Section 1.4, "Migrating Information from Previous Releases" Section 1.3, "Migrating User Settings from a Previous Release" Section 1.2, "Installing and Starting SQL Developer" Section 1.1, "SQL Developer System Recommendations" This chapter contains the following major sections: Please read the information in this chapter before you install Oracle SQL Developer. If you plan to use SQL Developer as part of an Oracle Database release installation, see the Oracle Database installation documentation. The IDE is not intended for beginners, targeting experienced programmers that work with the Oracle server.This guide assumes that you plan to download the SQL Developer kit (.zip) file and install it as a freestanding tool. Providing a diverse code template library, a built-in report generator, plugin functionality and a wide range of tools for easing the development process, PL/SQL Developer is a reliable and powerful utility for Oracle development. The configurable tree-view object browser allows fast navigation and the integrated file browser helps you quickly find your source and script files. The application can generate diagram representations of the database structures, allows automated regression testing and enables you to create and execute SQL scripts. Users can work with multiple connections simultaneously and access the DBMS database scheduler in Oracle. You can query parent and child records, insert or remove existing records, as well as generate graphical representations. The execution history is remembered and the results are neatly displayed in a grid. PL/SQL Developer comes with an integrated SQL editor that enables you to write and run SQL statements and PL/SQL blocks. ![]() The built-in debugger enables you to process any program units and detect the cause of occurred exceptions, while the code beautifier is designed to assist you in formatting the written source code using a set of predefined rules. Syntax highlighting, code completion and suggestions, refactoring and folding, code hierarchy, advanced navigation tools (hyperlinks, bookmarks, find and replace with regular expression support), a macro recorder, column editing tools, web searching are some of the advantages worth mentioning. The built-in Unicode compliant editor comes with a rich feature set that can meet the requirements of any user. Created especially for Oracle developers, PL/SQL Developer is a multi-threaded IDE that brings together a powerful editor, a debugger, a script writer and execution platform, a query builder and a wide array of functions that work together in order to allow the development of applications using Oracle databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |