Go to: Use of toad for Oracle

Http://blog.sina.com.cn/s/blog_4a93ccea0100ijd9.html

Use of toad for oracle tools

Source: Reprinted 

[Note: you can click an image to enlarge it.]

During the development of Oracle applications, it is a tedious and time-consuming task to access database objects and write SQL programs. daily management of databases also requires a lot of SQL scripts.Quest software provides an efficient Oracle Application Development Tool-toad (tools of Oracle application developers ).In the new version of Toad, the DBA (Database Administrator) module is added to help DBAs complete a lot of daily management work. It is easy to use and fast to access. With toad, we can quickly access the database through a graphical user interface to complete complex SQL and PL/SQL code editing and testing. Toad, designed by Oracle development experts for developers, is a powerful and compact professional PL/SQL development environment.

Toad has the following features:
Schema Browser ):
The Mode browsing function allows you to quickly access data dictionaries and browse tables, indexes, and stored procedures in databases. Toad provides quick access to the database, which is extremely convenient to use. The user interface is concise and the structure is reasonable. When we click a separate database object, toad immediately displays the details of this object. For example, when we click a database table, all indexes, constraints, stored procedures, SQL statements, and reference relationships with other tables related to the table are displayed on the same interface. To simplify operations, you can operate on all database objects in a browser window.

(Figure schema browser displays all database objects in "multi line tab" Mode)

 

SQL Editor ):
The main function of the SQL editor is to edit, run, and adjust SQL statements. The Toad advanced editing window includes many features to improve the productization of SQL statements written by developers. For example, you can simply generate a code template and automatically discover the package content and column name before writing SQL statements.
The SQL Editor contains an editing window and running result window, allowing developers to test the test run results during editing. The SQL editor includes not only standard editing commands, but also some enhanced functions, such as quick query of fields in the table and formatting of SQL statements. This window can process content up to 4 GB, which is very useful for large development projects. Convenient bookmarks make it easy for developers to find relevant locations. In the running result window, you can customize the configuration function and support long and long raw columns. You can detach data to a disk, print data, and edit data.

(Figure: select some SQL code snippets in the SQL editor for execution)

 

 

Stored Procedure Editor ):
The stored procedure Editor provides the following functions: editing, compiling, testing, and debugging stored procedures and triggers. Toad provides syntax, error, and many other easy-to-use functions, such as displaying table names, column names, and Oracle functions in the pop-up window. Unlike other PL/SQL editing tools, toad allows you to operate multiple database objects in one file, you can compile an object, compile multiple objects, compile to the current cursor, and compile from the cursor. When an error occurs during running, the stored procedure stops to a problematic statement. You can use shortcuts or templates to quickly compile PL/SQL statements, or generate your own templates as needed. Toad allows you to easily edit tasks, such as Setting bookmarks, uncommenting, and formatting SQL statements.

(Figure: In the Stored Procedure editor, you are ready to tune the SQL segment to SQL tunning)
 

 

 

SQL modeler ):

SQL modeler is a graphical SQL statement generation tool. You only need to drag the mouse to easily generate a variety of complex multi-Table query SQL statements.

(Figure: Write complex SQL scripts with the mouse "Drag & Drop)

 

 

Fastreport report designer:

Fastreport is a famous report engine in the industry. Toad is embedded with fastreport, which provides the ability to dynamically generate Custom reports. fastreport is extremely powerful. You can customize the Report Wizard to generate a pie chart, bar Charts, line charts, tables, and other forms of presentation. You can export the generated results to PDF, HTML, JPG, and BMP formats.

(Figure fastreport report designer)

 

 

 

Script Manager ):

Script Manager allows you to centrally manage common SQL scripts. You can also do the following: