Basic PL/SQL settings

Basic PL/SQL settings 1. How to export table creation statements in batches? Select [Tools]-> [Export User Objects...] from the menu, and select the table to be exported in the window that appears. The SQL script exported in this way does not contain insert statements, that is, the data in the table is not exported at the same time, only DDL statements. 2. How to export initialization data? Select [Tools]-> [Export Tables...] from the menu, in the displayed window, select the table to be exported, deselect the option [Delete records], and then export the script. 3. Display All query data Tools --> Preference --> Window Types --> SQL Window --> Records Per Page 4. view the oracle version select banner from sys. v _ $ version 5. automatically log on to PL/SQL Developer-> Tools-> preferences-> Oracle-> fixed login history users to enter information, such: www.2cto.com huilan231/123456@127.0.0.1/ORCL 6, beautify the SQL select the SQL statement to be formatted, and then click the PL/SQL beautifier button in the toolbar to 7, view the execution plan select the SQL statement to be analyzed, click the Explain plan button on the toolbar, or press F5. 8. Set the shortcut Key to open Tools> Preferences> User Interface> Key Configuration. Set the shortcut Key as follows: file/New/SQL Window Shift + S File/New/Command Windows Shift + A File/Close F4 Edit/ExcelPaste Shift + E www.2cto.com Edit/Selection/Uppercase Shift + U Edit/Selection /Lowercase Shift + L Edit/Selection/Comment Shift + C Edit/Selection/Uncomment Shift + V Tools/Window List Shift + W 9. when executing a single SQL statement using the SQL Window of PL/SQL Developer, press F8 and PL/SQL De By default, velock runs all SQL statements in the window. You need to set the SQL statement where the mouse is located to execute the current SQL statement. Setting method: PL/SQL Developer --> tools-> Preferences --> Window types --> SQL Windows, check "AutoSelect Statement. (Automatically select the statement) www.2cto.com 10. Import excel data Tools --> ODBC Importer --> PL/SQL function settings: Tools-> perferences-> UserInterface-> Connection (Excel Files) --> Connect (select an xls) --> Data From ODBC select an Import table --> select Data to Oracle (select Owner (log on to database) and Table) -> key Configuration File/new/SQL window Ctrl + n File/pl/sqlBeautiful Ctrl + d File/open/SQL script Ctrl + w www.2cto.com-> Code Assistant Mininute charts: 1. Enter 1 character.. Tools-> Window List: displays the SQL lists opened by pl/SQL Tools. You do not need to check the Window List every time after the following settings. By default, the Window List Window is not displayed, which is inconvenient. open the PL/SQL tool: Tools-> Preference-> User Interface-> Option, select Autosave desktop, and click apply 2. click Tools> tick Window List 3. disable the PL/SQL tool and re-open the PL/SQL tool. The Window List Window is automatically opened. 4. window List window closed: Tools-> Preference www.2cto.com-> key Configuration-> File Close (only Close the current windowList window)-> File Close All (Close All windowList Windows) f8 is automatically selected after query logon. My Objects is selected by default. After PLSQL logon, All objects will be selected in Brower. If you log on to dba, expand the tables directory, in normal cases, Wait takes several seconds, and the response speed after selecting My Objects is calculated in milliseconds. Setting Method: Tools menu --> Brower Filters. The order window of Brower Folders is opened and "My Objects" is set to the default one. Tools menu-Brower Folders: Move the directories you frequently clicked (for example, Tables Views Functions Procedures Packages Job) to the top, and add the color www.2cto.com tns to view the installation disk: \ oracle \ product \ 10.2.0 \ client_1 \ NETWORK \ ADMIN \ tnsnames. ora oracle Export and Import table views and data: 1. tools-> Export UserObjects-> select the table and view you want to Export. Yes. SQL file. 2. Tools-> Export Tables-> Dutput File (select the path ). Yes. When importing data in dmp file 3. Run the SQL file first. File-> New-> Command Window-> copy the. SQL File here. This operation first builds the table structure and view. Next, import the data. Tools-> Import Tables (select path). dmp file author yanghua812