PL/SQL Tool operations

--Object view switches to MyObject Setup method: Tools menu, Object Brower Filters, opens define Browser Filters interface, selects "My Objects" and tick "defaul  T "is set to default. The Tools menu, Object Brower Folders, will open the Define Browser Folders interface, where you can put several frequently used directories (e.g. Tables views Seq Functions Procedures) --Find database objects Global Search Databases object--preferences provided by tools--Preferences 1. Settings remember user name password 2. Keyword Case 3. Save the last Open SQL script (1) to tools-> the menu The window list option is ticked, (2) Tools->perferences->user interface->options to the right, and "Autosave desktop" is selected.--the menu bar provides the function 1. Format SQL Statement PL/beautifier--Preferences to import your own template2. View execution plan explain plan or f5--debug 1. Debug CONNECT SESSION permissions missing, stored procedure Debug error: Insufficient privileges. (1) Sqlplus:/As Sysdba; (2) Grant DEBUG CONNECT SESSION to Scott, (3) SELECT * from Role_sys_privs where privilege like ' debug% ' ORDER by 2;2. Error: Automatic STATISTICS v$session Dynamic Performance View no access (1) Check no longer prompt (rookie program) (2) grant the user permission to query grant SELECT on V$sessi On to USER_SEC (3) Authorization for all users: Grant Select on V_$session to Public, (4) Disable Plsql This feature Tools--Preferences--and Options---Automatic statistics--The Oracle thin client configuration \oracle\ora90\network\admin\tnsnames.ora file 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))--EXECL data Import Database CREATE TABLE T1 (CIN o varchar2 (+), Contno varchar2 (+), Loanno varchar2 (+)) SELECT * from T1 (1) SELECT * from T1 for UPDATE; (2) copy-stick Paste Quick Insert--double-click the Show Table Data setting Method: Menu Tools, Preferences, Object Browser, on the right, double-click and drag-and-drop operations for different Object type bindings. --The Italic style menu with the annotation removed the User interface->editor in the right interface, Preferences "Syntax highlighting", remove the "Comment" to the right of "   Italic "is selected.

　　

PL/SQL Tool operations