PL/SQL Developer functions of various windows, pldeveloper
Understanding the functions of each window is the primary condition for the correct use of PL/SQL Developer. The following briefly describes the functions of PL/SQL Developer windows:
-Program window ):SQL and SQL plus statements, such as stored procedures and methods, can be executed.
Test window: usually used to test the debug of stored procedures.
-SQL window ):Dml and ddl statements are executed, which are used to query and Display User statements (the most widely used window ).
-Report window ):It can be used to conveniently display windows in the form of charts with aggregated queries, such as sum () and count (), with x and Y axes.
-Command window ):In addition to SQL and sqlplus commands, you can also execute more commands, such as call.
-Explain plan window ):Explain the execution plan, which is often used during optimization.
-Digraphs ):I don't know how to draw charts.
Copyright Disclaimer: Welcome to repost