PL / SQL Developer with skills summary (rpm)

2011-04-24  来源:本站原创  分类:Database  人气:106 

The following tips only for PL / SQL Developer 6 or later, version 5 only one part of the property.
1, right-click menu in PL / SQL Developer (below referred to as PLD) in a text editor window for each, such as the SQL Window, Command Window and Porgram Window, right-click an object name will pop up a menu containing the command operation object, we This is called right-click menu. Below:
Object type can be a table, view, synonym, stored procedures and functions and so on. According to the different object types, there are differences between the pop-up menu. Tables and views are View, Edit, Rename, Drop, Query data and Edit data and other functions. View and Edit are to view and modify table structure information, such as fields, primary keys, indexes, and constraints. Query data is equivalent to open a new window, and execute select * from table. Edit data equivalent to open a new window, and execute select * from table for update. Test stored procedures and functions are functions, selected after entering debug state.
Sometimes, because PLD recognition errors, right-click the object and can not come out right menu, the object is located in the DDL or DML statements in front of a semicolon, so that the PLD will be able to determine the correct object type
2, Select for Update
Sometimes we need to put some data into the database, if you fight with the UE Insert statement, would be more trouble, but not strong. SQL Window of PLD can query, add, modify, and delete the contents of the table. Query Needless to say, and add, delete and modify, just in a select statement to join for update, the table row-level locking, and then click on the window lock icon, you can enter edit mode.
Here's how to extract text from Excel into an Excel database, we have three files:
Create temporary table in the database:
create table t1 (cino varchar2 (100), contno varchar2 (100), loanno varchar2 (100))
Then in the SQL Window, enter select t1 for update, and click the lock-type mouse, and enter edit mode:
Right-click on the first line of the input window, then the PLD will deadlock a few seconds, then you can see the cursor in the first row of the input box flashing, use the mouse to CINO, CONTNO, LOANNO selected:
Into Excel, the need to insert the contents of the database is selected, then switch to the PLD, press Ctrl + V:
Click √, then click the Commit button, the data submitted to the table t1, perform select * from t1 can see the contents:
3, PL / SQL Beautifier
PLD 6 above have the function of the DML code formatting. In the SQL Window or Program Window, select the part of the code (if you do not choose the code for the operation of the entire window), select the menu Edit à PL / SQL Beautifier, to be formatted code. For DML statements or illegal DDL statements, PLD will be at the bottom status bar PL / SQL Beautifier could not parse text.
In the default state, PLD will DML statements are ranked in each field a separate line, this is not convenient viewing. In the menu select Edit à PL / SQL Beautifier Options, enter the Preferences window, select Edit, edit the configuration file into the interface:
Select the tab bar DML, in the middle of the window Select, Insert and Update group box, select the Fit, and then click Save, the PLD configuration file to the installation directory, click Close to close. In the Rules file, enter the location of the configuration file, click OK, complete the switch configuration file. Then re-format the code, you can make as much as possible in each field on the line.
4, TNS Names
Menu Help à Support Info à TNS Names, you can view the Oracle tnsnames.ora.
5, Copy to Excel
In the SQL Window Select statement executed, the results came out, right-click on the following data areas, select the Copy to Excel, you can record the data area of ​​the intact copy to Excel. But there are two points to note: First, field can not start with =, otherwise Excel will mistakenly think that is a function; two, not more than 17 numbers, or bits will be set back to zero, but can be preceded by the numbers 'to make Excel that the field is text, while for the database Numbe type of field, it is best to use to_char output, or may not display properly

Skills:

1, PL / SQL Developer Password Remember me

Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password;

Setting method: PL / SQL Developer 7.1.2 -> tools-> Preferences-> Oracle-> Logon History, "Sto
re history "is checked by default, the hook on" Store with password "to re-enter a password at login is remembered.

2, execute a single SQL statement

Using PL / SQL Developer of the SQL Window, press the F8 key, PL / SQL Developer default implementation of the window all the SQL statements, you need to set the mouse to which the SQL statements that execute the current SQL statement;

Setting method: PL / SQL Developer 7.1.2 -> tools-> Preferences -> Window types, hook on "AutoSel
ect Statement "can be.

3 Formatting SQL statements

Using PL / SQL Developer of the SQL Window, sometimes enter the SQL statement too long or too messy, hoping to pass more
Format, then look at the wording used, so it looks look better, beating analysis;

Usage: Select the format of the SQL statement, and then click on the toolbar of the PL / SQL beautifier button.

4, view the execution plan

Using PL / SQL Developer of the SQL Window, sometimes enter the SQL statement execution efficiency analysis in the following table structure,
How can improve the efficiency of query, you can view the Oracle provides for its implementation;

Usage: Select the SQL statement analysis, and then click the Explain plan button on the toolbar (that is, implementation plan), or you can directly press F5.

5, debugging stored procedures

Using PL / SQL Developer Oracle operation, sometimes called some of the stored procedure, or debugging stored procedures;

Call the stored procedure method: First, PL / SQL Developer on the left of the Browser, select Procedures, find the need to call the stored procedure; then select debug stored procedures, right click and select Test, the Test scrīpt in the pop up window. For the type defined in the parameters need to input the parameter values ​​Value; Finally, click the button above the number of articles: Start
debugger or press F9; Finally, click on: RUN or Ctrl + R.

(Specific to tuning a stored procedure, the operator's manual, the instructions about the next application).

6, oralce the use of thin client

To PL / SQL to connect oracle database, in addition to PL / SQL Developer needed in addition to the Oracle client, there is a more convenient way is to use the Oracle thin client, many can be downloaded, the file is very small, less consumption of resources. After installation is complete, modify the installation directory \ Oracle \ ora90 \ network \ ADMIN \ tnsnames.ora file: the following format:

DATABASE_NAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(CONNECT_DATA =
# (SERVICE_NAME = dealer)
(SID = SID_NAME)
# (SERVER = DEDICATED)
)
)
7 keywords automatically capitalized:

Programming knowledge to understand that people know that coding style is very important. In reading the code, the consistent coding style, is easier to read; in the implementation of efficiency, consistent coding style, are more likely to be placed in the shared SQL area, so it provides the efficiency of execution.
Set is very simple: Tools-> Preferences-> Editor, select the Keyword case Uppercase.
I usually make keywords uppercase, the other such as table names, field names are all lowercase. We should develop a habit of their own code, and maintained.

相关文章
  • PL / SQL Developer with skills summary (rpm) 2011-04-24

    The following tips only for PL / SQL Developer 6 or later, version 5 only one part of the property. 1, right-click menu in PL / SQL Developer (below referred to as PLD) in a text editor window for each, such as the SQL Window, Command Window and Porg

  • (R) PL / SQL Developer with skills 2011-01-20

    1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2 -> tools-> Preferences-> Or

  • PL / SQL Developer practical skills 2010-07-29

    Oracle database is believed to have a lot of companies build their business-critical support for the importance of the background, is often used by many developers back. However, Oracle provides its own set of client-side tools are not useful, a grea

  • PL / SQL Developer with skills in common 2011-05-17

    [Align = left] 1, login by default automatically selected My Objects By default, PLSQL Developer login, Brower Lane will choose All objects, if you logged on user is dba, to expand the tables directory, normally need to Wait a few seconds, and select

  • PL / SQL Developer with skills 2011-07-31

    1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2 -> tools-> Preferences-> Or

  • PL / SQL Developer with skills (turn) 2011-04-25

    1, right-click menu In PL / SQL Developer (below referred to as PLD) in a text editor window for each, such as the SQL Window, Command Window and Porgram Window, right-click an object name will pop up a menu containing the command operation object, w

  • Oracle uses the skills and PL / SQL Developer configuration 2010-12-03

    PL / SQL Developer with skills 1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2

  • PL / SQL Developer Skills 2010-07-30

    1, PL / SQL Developer Login Password Remember Using PL / SQL Developer, in order to facilitate the work of hope PL / SQL Developer Oracle Remember login user name and password; Set Method: PL / SQL Developer 7.1.2 -> tools-> Preferences-> Oracle-

  • Do not install the Oracle client to run pl / sql developer (rpm) 2010-09-25

    Sql client, although the most convenient is extremely versatile and lightweight Sql Workbench, the only regret is that only supports JDK5, but this little regret as long as the configuration configuration can be avoided. Otherwise, Oracle, the use of

  • An official free version of Oracle client, use the PL / SQL Developer Connection Oracle__ own summary 2011-03-25

    Thanks: jslfl, refer to: http://jslfl.iteye.com/blog/788831 A security official free version of Oracle client, connect to the database method 1, http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html download Instant Cli

  • PL / SQL Developer Baocuo Dynamic Performance Tables not a 2010-03-29

    Using the PL / SQL Developer tool for landing a newly created user query, quoting the following error (PL / SQL Developer Version: 7.1.5 1403): Dynamic Performance Tables not accessible, Automatic Statistics disabled for this session You can disable

  • PL / SQL Developer Tips 2010-04-13

    PL / SQL Developer Tips 1, PL / SQL Developer remember the login password when using PL / SQL Developer, in order to facilitate the work of hope PL / SQL Developer Oracle Remember login user name and password; Set Method: PL / SQL Developer 7.1.2 ->

  • PL / SQL Developer practical techniques (transfer) 2011-06-16

    Oracle database is believed to have become the key to many companies build their own business, an important background support, but also many developers often use the background. However, Oracle provides its own set of client tools are not very good,

  • Free installation of Oracle to run pl / sql developer 2010-02-16

    Sql client, although the most convenient is universal and extremely light weight of Sql Workbench, the only regret is that only supports JDK5, but this little regret as long as the configuration configuration can be avoided. Otherwise, Oracle is usin

  • win7 x64 installation oracle10g x64 and PL / SQL Developer 8.02 2010-03-18

    1, oracle10g installation is relatively simple 1. To download the Vista version of Oracle Oracle: Oracle Database 10 g Release 2 (10.2.0.4) for Microsoft Windows Vista x64 and Microsoft Windows Server 2008 x64 2. Unzip the downloaded installation fil

  • windows under the PL / SQL Developer Installation Guide 2010-03-19

    Host Environment: win xp Database: oracle 11gR2 32bit PL / SQL Developer 7.15 Steps are as follows: Fortunately found a free installation of Windows, the client can use Oracle pl / sql developer handy way to share: 1, the installation plsqldev715.exe

  • PL / SQL DEVELOPER basic Detailed description 2010-03-25

    PL / SQL DEVELOPER basic Detailed description (proposal written after the first stored procedure, the initial hand must-read) Used the oracle of all complaints, in order to stabilize its operation to provide graphical slow sad ah, p4 +128 M to start

  • PL SQL developer to export data 2010-04-15

    If only export the table structure (built table statement), does not export the table data can be used Tools - Export User Objects Select to export the table, set up to export the path and all parameters, click Export on the OK PS: this approach is t

  • PL / SQL Developer to connect to the database 2010-05-02

    First, it should install the oracle client and install pl / sql developer. Modify the D: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ tnsnames.ora Quote SNDEV = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 0.0.0.0) (PORT = 11111)) (CO

  • Install only the Oracle client to use PL / SQL developer login oracle server 2010-05-25

    1, download oracle_client to the local. 2, install the client, select 178M of that is to install only the client 3, the installation is complete in the command line, type sqlplus, if you can use that installed the 4, and now, of course, can not conne