how to run pl sql program in command prompt

Chapter 2 procedural performance tuning of PL/SQL applications I. Reasons for PL/SQL Performance problems When the execution efficiency of PL/SQL-based applications is low, it is usually caused by poor SQL statements and programming methods,

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,

PL/SQL usage tipsEdit/undo Ctrl+zedit/redo shift+ctrl+zedit/pl/sql beautifier ctrl+w (Custom) Shift+home Select the cursor position to the beginning of the line Shift+end select the cursor position To the end of the line Ctrl+shift+home select the

Shortcut:===============================================================================Edit/undo Ctrl + ZEdit/redo shift+ctrl+zEdit/pl/sql beautifier ctrl+w (Custom)       shift+home  Select the cursor position to the beginning of the line       

1. PL/SQL Developer remember login password when using PL/SQL developer, in order to work conveniently hope PL/SQL Developer remember login Oracle user name and password; Setup method: PL/SQL Developer->tools->preferences->oracle->logon history,

1. My Objects is automatically selected by default after logon.By default, after PLSQL Developer logs on, All objects will be selected in Brower. If the user you log on to is dba, it will take several seconds to expand the tables directory, after

1. My Objects is automatically selected by default after logon.By default, after PLSQL Developer logs on, All objects will be selected in Brower. If the user you log on to is dba, it will take several seconds to expand the tables directory, after

1, default automatically check my Objects after loginBy default, after Plsql developer is logged in, Brower will select all objects, and if you are logged on as a DBA, you will need to wait a few seconds for the tables directory to expand, and the

The following tips only apply to PL/SQL developer 6 and later versions. Version 5 only has some features.1. Right-click the menuRight-click an object name in each text editing window in PL/SQL developer (PLD), such as SQL window, command window, And

Solve PL/SQL Dev connection to Oracle a blank prompt box appears, ploracle The first time Oracle was installed, it was installed in a virtual machine. When PL/SQL Dev was used to connect to a remote database, a blank prompt box pops up. After a long