Plsql Developer Setup Tips

1, right-click menu in PL/sql Developer (hereinafter referred to as PLD) in each of the text editing window, such as SQL window,command window and Porgram window, right-click on an object name, will pop up a menu containing the Action Object command, We call this a right-click menu. Object types can be tables, views, synonyms, stored procedures, functions, and so on. The menu that pops up differs depending on the type of object. Tables and views have features such as view, edit, Rename, Drop, Query data, and edit data. View and edit are the structure information for viewing and modifying tables, such as fields, primary keys, indexes, constraints, and so on. Query data is equivalent to opening a new window and executing the SELECT * from table. Edit data is equivalent to opening a new window and executing the SELECT * FROM table forUpdate. Stored procedures and functions have the test function and can be checked to enter the debug state. Sometimes due to PLD recognition error, right-click on the object does not come out the correct menu, can be in the object's DDL or DML statement before, plus a semicolon, so that PLD can correctly determine the type of object2. Select forUpdate sometimes we need to import some data into the database, if you use the UE spell INSERT statement, it will be more troublesome, and not strong. PLD SQL window can query, add, modify and delete the contents of the table. Query from needless to say, and new, delete and modify, just after the SELECT statement to add for update, the table row-level lock, and then click the window lock icon, you can enter the editing state. Here's how to extract text from Excel insert into a database there are three columns in our Excel file: Create a temporary table in the database: Create TABLE T1 (Cino varchar2 ((+), Contno varchar2 (+), Loanno varchar2 (100)) then enter select T1 in SQL window forUpdate, and click on the lock-type mouse, enter the editing state: Click on the first line of the input window, PLD will deadlock a few seconds, and then you can see the cursor in the first line of the input box flashing, with the mouse to CINO, Contno, Loanno selected: Into Excel, Select the content that needs to be inserted into the database, then switch to PLD, press CTRL + V: Click Yes, then click the Commit button, then submit the data to the table T1, execute SELECT *From T1 You can see the content:3, PL/SQL Beautifier (pl/SQL beautification) PLD 6 or later has the ability to format DML code. Select a portion of the code in the SQL window or program window (if you do not select the code for the entire window), select Edit in the menu-PL/SQL Beautifier, get the formatted code. For illegal DML statements or DDL statements, PLD will prompt PL/SQL Beautifier could not parse text in the status bar below. In the default state, PLD will arrange each field of the DML statement in a separate line, so it is not easy to see. Choose Editàpl/sql beautifier Options in the menu, go to the Preferences window, select Edit, go to the profile editing interface: Select DML in the tab bar, in the middle of the window, In the Insert and update groups box, select Fit and click Save to save the configuration file to the PLD installation directory, and click Close. In the rules file, enter the location of the configuration file, click OK to complete the profile switch. Then you can format the code so that each field is as close as possible on one line. 4, TNS Names menu Helpàsupport infoàtns Names, you can view the Tnsnames.ora of Oracle. 5, Copy to Excel executes the SELECT statement in SQL window, after the result, right click on the data area below, select Copy to Excel, you can copy the data area record to Excel. But there are two points to note: First, field cannot be=start, or Excel will be mistaken for a function, two, the number should not exceed 17 bits, otherwise the number of digits will be set to 0, but you can make Excel think that field is text by the number in front, and for the Numbe type field in the database, it is best to use to_char output, Otherwise, it might not show up properly .6, PL/SQL Developer remember login password in the use of PL/SQL developer, in order to work convenient hope pl/SQL Developer Remember to log in to Oracle user name and password; Setup method: PL/sql Developer 7.1.2->tools->preferences->oracle->logon, "Store History" is checked by default, tick "store with Password "can, re-login at the time of entering the password is remembered. (I can't seem to be OK) 7, execute a single SQL statement using PL/sql Developer SQL window, press the F8 key, pl/SQL developer defaults to all SQL statements that execute the window and needs to be set to the SQL statement where the mouse is located, executing the current SQL statement; setting method: PL/sql Developer 7.1.2-->tools->preferences-->window types, hook up "AutoSelect Statement" can be. 7, formatted SQL statements using PL/sql Developer SQL window, sometimes the input SQL statement is too long or too messy, I hope to use a more general format words, so look good, or analysis; How to: Select the SQL statement that you want to format, and then click PL/N on the toolbar Beautifier button. 8, viewing the execution plan using PL/sql Developer SQL window, sometimes input SQL statement execution efficiency, analysis of the following table structure, how to improve the efficiency of the query, you can view the execution plan provided by Oracle;To use: Select the SQL statement you want to analyze, and then click the Explain Plan button on the toolbar (that is, execution plan), or press F5 directly. 9, the debug stored procedure uses the PL/sql Developer when operating Oracle, some stored procedures are sometimes called, or stored procedures are debugged, and methods of calling stored procedures: first, select procedures in the browser to the left of PL/SQL developer to find the stored procedure that needs to be called Then, select the debug stored procedure, right-click, select Test, in the Test Scrīpt window, for the parameter defined in the type, you need to give the value of the parameter values; Last click the number of bars button: Start debugger or press F9 ; Last click: RUN or Ctrl+r.(in order to tune a stored procedure, please refer to the operating manual, this is probably the application of the instructions). 10, Oralce thin client use to PL/sql Connect Oracle database, in addition to PL/SQL Developer also requires Oracle client, there is a more convenient way is to use the Oracle thin client, many places can be downloaded, the file is small, the cost source is also low. After installation, modify the/oracle/ora90/network/admin/tnsnames.ora file in the installation directory: The format is as follows: 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)))  PLHow to automatically prompt for fields when entering SQL statements in/sqlTools-P

Plsql Developer Setup Tips