PL/SQL developer Introduction

Http://hi.baidu.com/yunfanleo/blog/item/fa65fcfd91916346d7887d25.html

PL/SQL developer
	PL/SQL developer is an integrated development environment dedicated to the development of Oracle database storage program units. Nowadays, more and more business logic and application logic are turning to Oracle server. Therefore, PL/SQL programming has become an important part of the entire development process. PL/SQL developer focuses on ease of use, code quality, and productivity, and gives full play to the main advantages of Oracle application development.
Main features of PL/SQL developer:   PL/SQL editor, powerful functions-the editor has enhanced syntax, SQL and PL/SQL help, Object Description, code assistant, compiler prompt, PL/SQL improvement, code content, code classification, browser buttons, hyperlinks navigation, macro library and many other smart features, able to meet the most demanding user needs. When you need a certain information, it will automatically appear. You can click at most to call up the information. Integrated debugger (Oracle 7.3.4 or higher is required)-This debugger provides all the features you need: Step in, skip (step over), and step out) when an exception occurs, stop running, break points, observe and set variables, and observe all stacks. It can basically debug any program unit (including the trigger and oracle8 object type) without any modification. PL/SQL optimizer-this optimizer allows you to standardize SQL and PL/SQL code using user-defined rules. The code is automatically normalized when a file is compiled, saved, and opened. This feature improves the coding productivity, improves the readability of PL/SQL code, and facilitates collaboration between large-scale teams. SQL window-this window allows you to enter any SQL statements and observe and edit the results in a grid format. It supports the sample-based query mode to search for specific records in a result set. In addition, it also contains historical caches, allowing you to easily call previously executed SQL statements. The SQL Editor provides the same powerful features as the PL/SQL editor. Command window -- use the PL/SQL developer command window to develop and run SQL scripts. The window has the same feelings as SQL * Plus, and a built-in script editor with enhanced syntax is also added. In this way, you can develop your own scripts without the need to edit, save, and convert the script to SQL * Plus or run the script process, or leave the PL/SQL developer integrated development environment. Report -- PL/SQL developer provides the built-in report function. You can run reports based on program data or Oracle dictionary. PL/SQL developer provides a large number of standard reports, and you can easily create custom reports. The custom report is saved in the report file and then included in the Report menu. In this way, it is very convenient to run Custom reports that you often use. You can use the free query Reporter software tool to run your report. You can run the report directly from the command line without PL/SQL developer. Engineering-the built-in engineering concepts of PL/SQL developer can be used to organize your work. A project includes a collection of source files, database objects, notes, and options. PL/SQL developer allows you to work within a specific set of entries, rather than within a full database or architecture. In this way, if you need to compile all the project entries or move the project from a location or database to another location, the search for the required project entries becomes easier, To-Do entry-you can use the to-do entry in any SQL or PL/SQL source file to quickly record the items in the file. In the future, you can access this information from the to-do list. Access operations can be performed at the Object layer or project layer. Object Browser-configurable tree views can display all information related to PL/SQL development, this browser can be used to obtain object descriptions, browse object definitions, create test scripts for debugging, enable or disable triggers or constraints, recompile illegal objects, query or edit tables, and browse data. search Text in the object source, drag and drop the object name to the editor, and so on. In addition, the browser can display the dependency between objects. You can recursively extend these dependency objects (such as package reference check, browse reference tables, and chart types ). Performance Optimization-with PL/SQL profiler, you can view the timing information of each executed PL/SQL code line (Oracle8i or higher ), to optimize the code performance of your SQL and PL/SQL. Furthermore, you can automatically obtain the SQL statements executed and PL/SQL program statistics. The statistical information includes CPU usage, block I/O, record I/O, table scan, and classification. HTML guide-Oracle currently supports online guide in HTML format. You can integrate it into the PL/SQL developer work environment to provide content-sensitive help when an error occurs during editing, compilation, or running. Non-PL/SQL objects-without any SQL, you can browse, create, and modify tables, sequences, symbols, libraries, directories, jobs, queues, users, and roles. PL/SQL developer provides a simple and easy-to-use form. As long as the information is entered, PL/SQL developer generates the corresponding SQL to create or convert objects. Template list-the PL/SQL developer template list can be used as a real-time help component to help you enforce standardization. Click the template to insert standard SQL or PL/SQL code to the editor, or create a new program from the draft. Query Builder-graphical Query Builder simplifies the creation and modification of new and existing statements. Drag and Drop tables and windows, select columns for the region list, and define a Union table based on the external key constraints. Compare user objects-after modifying table definitions, views, and program units, it is very useful to pass these modifications to other database users or check the differences before and after the modifications. This may be another development environment, such as the test environment or production environment. The Compare user object function allows you to compare the selected objects, visualize the differences, and run or save the SQL scripts necessary for the application changes. Export user objects-this tool can export the DDL (Data Definition Language) statements of the objects selected by the user. You can easily recreate objects for other users, or save files as backups. Tool-PL/SQL developer provides several tools to simplify daily development. Using these tools, you can recompile all illegal objects, search for texts in the database, import or export tables, generate test data, export text files, monitor dbms_alert and dbms_pipe events, and view session information. Authorization-in most development environments, you do not want all databases to have all the functions of PL/SQL developer. For example, in database development, you can allow all functions of PL/SQL developer, while in database testing, you can only allow data query/editing and object browsing, you do not even want PL/SQL developer to access the database during database creation. With PL/SQL developer authorization, you can easily define features that a specific user or rule can use. Plug-in extension-PL/SQL developer functions can be extended through the plug-in. The add-ons page provides plug-ins for free download. Allround automations or other users can provide plug-ins (such as version control plug-ins or plsqldoc plug-ins ). If you have the programming language for creating DLL, you can also compile the plug-in by yourself. Multithreading IDE--PL/SQL developer is a multithreaded IDE. In this way, you can continue to work when SQL queries, PL/SQL programs, debugging sessions, and so on are running. In addition, this multi-threaded ide means that the program will not be aborted when a programming error occurs: You can interrupt the execution or save your work at any time. Easy to install-Unlike SQL * Net, no middleware or database object installation is required. Click the installer button to start the installation and use the software.