Home

Sql Developer User Manual

image

Contents

1. lt 2 Sessions 12 4 6 Monitor With the Monitor extension you can monitor important values of an Oracle database instance periodically If the auto refresh option is checked new measured values are recorded repeatedly after the selected period 5 seconds to 10 minutes has elapsed Note Usually you need DBA privileges to access the system views required for monitoring a Monitor HAWKUTFS system Auto refresh SSeconds Logical 1 0 Physical 1 0 Call rates lO second calls second 0 0 0 23 06 00 23 06 30 23 07 00 23 07 30 23 08 06 00 23 06 30 23 07 00 23 07 30 23 08 23 06 00 23 06 30 23 07 00 23 07 30 23 08 Block changes Block reads Consistent reads we Reads Writes Redo writes Parse Execute Commits Rollbacks Event waits Indexed queries Sessions waits second 8 4 J 0 1 4 ee 23 06 00 23 06 30 23 07 00 23 07 30 23 08 2 Control File O single block read _ oo o p i multi block read direct path read SQL Net 23 06 00 23 06 30 23 07 00 23 07 30 23 08 23 06 00 23 06 30 23 07 00 23 07 30 23 08 File VO log write other indexed non indexed total background inactive active 44 44
2. List CHIMERA LINK TERMS CHIMERA LINKS CHIMERA ALLOWED_ELEMENT_TYPES CHIMERA LANGS CHIMERA GLOBAL ACCESS CONTROL CHIMERA ELEMENT_TYPES CHIMERA ALLOVED_SUB_PAGES CHIMERA ACCESS CONTROL LIST Cancel 38 44 SQL Developer User Manual 12 2 Microsoft SQL Server extensions 12 2 1 Show Plan With the Show Plan extension you can analyze the SEE execution plan of a query Paste the statement to ao analyze from the clipboard into the SQL editor in the p Productilane ero northwind products p upper part of the dialog You can also load a cee ee northwind suppliers s statement from a file using the Open function we Cesc p CategoryID lt 1000 Use the Execute button from the tool bar to analyze the statement The Execution plan will be displayed in a tree in the lower part of the dialog gi Modified Insert Execution plan SELECT cost 0 021052586 2 1 Nested Loops Inner Join cost 0 021050276 GG Bookmark Lookup cost 0 012707889 A Index Seek cost 0 0064324792 i0 Clustered Index Seek cost 0 0082458295 12 2 2 Processes This extension shows all processes running on the database for the currently selected adapter Use the Details button to show the last executed SQL command for the selected process With the Kill process button you can ever terminate the selected processes The 9314 Fite nome vie emag Refresh button re reads all Information anat ThreadID Bloc
3. the right half Hides the detail view and shows the tree view only 28 44 SQL Developer User Manual 8 Diagram Editor With the diagram editor you can visualize database catalogs and schemas Predominantly the diagram editor is intended to support reverse engineering of existing databases E C sample sqlddm x Wy es UT PERSON_ATTRIBUTES L PERSON_KEY_ATTRIBUTES L PERSON_KEY_VALUES PERSON_VALUES Mi PERSONS UGR_USERS PKV_FIKA_FK A USER_GROUP_GROUPS L USER_GROUP_KEY_ATTRIBUTES L USER_GROUP_KEY_VALUES LU USER_GROUPS M WELL_KNOWWN_PERSONS PKV_PER_FK WKP_PER_FK PV_PER_FK Use the File menu to create a new diagram or to open or save an existing 8 1 Components 8 1 1 Object list The object list shows all diagram objects in ascending alphabetically order For easy recognition of an object tts background color is displayed on the left of each list entry References between the diagram objects are not shown by this list Select one or more objects from the list to perform a function on them The list selection is always synchronized with the selection of the diagram view 8 1 2 Overview The overview displays the diagram from the bird s view and shows the visible region of the diagram view with a marker frame You can use the mouse to modify the frame s size and position to control the zoom factor an the visible region of the diagram 8 1 3 Diagram view The diagram view shows the d
4. URL All other tabs contain specialized connectors for ue various databases Use the nfo button to check if the driver required for a specialized connector 7 is already available You can edit the Driver SE Settings directly from the connection dialog to i add missing drivers v Click the OK button to confirm the settings for the current tab and to establish a new database connection 6 44 SQL Developer User Manual 3 Desktop The desktop of the application consists of the following components pa A 7 5 Context menus Main menu and tool bar Database Navigator Output window and Bookmarks MDI Multiple Document Interface window area Some components Database Navigator output window and bookmarks can be individually positioned on the desktop by the user Click on the tab of the component to move and drag the component to its new target position a SQL Developer File Edit Extras Window Help amp G G 5 HADUTFS NEG SOLYP DE system 72Y pRB ANG 2 amp Database Navigator 2 emp E sfsrepos sqlddm 2R EREBX 4 kA A OC OLAPSYS ORDPLUGINS ORDSYS OSCAR OSCAR2 OSCARCTXAPP OUTLN Q5_CBADM Q5_C5 Q5_E5 Q5_05 Q5_WS RMAN SCOTT 53 Tables Gf BONUS A DEPT o a Ea PECCEEE ESSE SESE E E Columns H Indexes Constraints S 2 PK_EMP pr o 8 EMPNO F
5. access to all vendor specific extensions Opens the Settings dialog Arranges all windows excluding the navigator and output window on the desktop by overlapping them Arranges all windows excluding the navigator and output window on the desktop as tiles in a vertical orientation Arranges all windows excluding the navigator and output window on the desktop as tiles in a horizontal orientation Closes all windows excluding the navigator and output window At this position you find a list of all open windows Shows the Tip of the day Opens the license dialog to register SQL Developer Connects to the Internet and searches for updates of SQL Developer Opens a web browser and navigates to the SQL Developer homepage Shows general information about SQL Developer 10 44 SQL Developer User Manual 3 2 Tool Bar The tool bar is located below the main menu and provides access to a number of important functions a E HADUTFS NEG SOLYP DE system OR AR AS NF LRO Within the tool bar you find a dropdown list showing all open database connections You can switch to another connection than the current simply by selecting an entry from the list The list automatically switches if a connection is selected indirectly by the database navigator or an editor window Opening a new editor window always connects to the database shown as the current connection in the list 3 3 MDI Window Area All SQL editors and non
6. fe 1 1 v P 0000 0010 80 00 00 00 80 00 80 80 00 00 00 80 80 00 80 00 A KX 0000 0020 80 80 CO CO CO CO DC CO A6 CA FO 4A 40 92 7A 2F JB z 0000 0030 2C 7F 3F 3E 77 58 40 84 78 39 64 5B 6E 88 6F 60 2 gt wXB x9d n o 0000 0040 24 1C 92 2E 2B 96 35 35 90 44 40 92 57 54 90 6B 55 08 UT E 0000 0050 SF 8D 7C 74 8D 9B 37 34 9B 46 45 BS 37 34 B3 47 _ t 74 FE 74 G 0000 0060 45 98 58 54 A8 59 59 B9 50 4E B9 SE SE 9C 8B 41 E XT YY PN A 0000 0070 9C 81 65 Bl 79 67 9D 72 7E B4 75 73 9F 89 84 B9 e yg r us 0000 0080 83 85 00 FF 00 94 94 94 9C 94 7B 9C 94 BC OC 94 lo 0000 0090 94 9C 9C 84 9C 9C 8C AS 94 84 AD 9C ZE AS 9C 52 0000 0040 AS 9C 67 AS 9C 73 AS 9C 7B AS 9C 8C AD 94 94 B3 g s 0000 0050 9F 3E BD AB 3B B5 Ad 44 Bl 9C 52 AE OF SD B9 A gt 7 J R 0000 00C0 54 BD AD 5A AD 9F 6D B5 A5 69 B9 AB 6B BA AF 70 T Z m i k p 0000 00D0 Bl Al 85 B6 AA 86 BB B3 7F BD Bl 90 lE 1A B3 2F 0000 0080 2E BS 1C 16 D2 2F 27 CB 40 36 BB 52 4E AD 4D 44 1M6 RN 0000 00F0 CB 18 14 E 25 23 EC 2D 24 EB 37 35 E6 35 35 FB 75 55 0000 0100 44 48 ES 44 44 FF 64 60 AD 79 6F A 63 SF CD 77 JH JJ d yo c_ w 0000 0110 6F C9 86 81 AS 86 83 BA 83 81 CC 65 65 ES 64 69 0 ee ji 0000 0120 F 7B 76 E9 78 75 FC 88 85 DA 87 80 EB 81 7F FD v xu I BLOB viewer with hexadecimal and image view 21 44 SQL Developer User Manual 6 1 2 CLOB View
7. of the active editor window to a file This function is available after an editor window has been titled with a filename after an Open or Save as operation Writes the content of the active editor window to a file with a new filename This function gets available after an editor window has been opened for a connection Opens a new Diagram Editor Opens a diagram file Writes the current diagram to a file This function is available after an editor window has been titled with a filename after an Open diagram or Save diagram as operation Writes the current diagram to a file with a new filename Prints the content of the active window Exits the application All open connections are closed automatically 8 44 SQL Developer User Manual 3 1 2 Edit AB AE AE E SQL Statement SQL Script Stored Program Editor Find Replace Go to line Toggle comment Convert to upper case Convert to lower case Convert to mixed case identifier Convert to upper case identifier Enclose in quotes Remove enclosing quotes Char map Encoding Opens a new editor window for single SQL statements on the current connection Opens a new editor window for SQL scripts on the current connection Opens a new editor window for stored procedures on the current connection Opens the Find dialog Opens the Replace dialog Jumps to the specified line in the active editor window Comments or un
8. optional and enables you to enter a profile name manually If the field is left empty SQL Developer automatically generates a name for the connection In the arguments table you can define additional connection parameters as name value pairs The table expands automatically when entering a name in the Arguments Select the arguments you want to specify as connection parameters Required Value Description first column To remove a name value pair just delete CN Se TUE the name in the first column of the desired entry p a De 3 LE d tr Password to use for auth Some drivers provide information about their supported sms fake ne E lt gt arguments Press the Supported arguments button to show them in the Arguments dialog and to copy selected arguments to the table 5 2 Port Scanner With the Port Scanner you can determine if a Server is accessible WEZI through one or more ports Host hawkfish Use the Scanner e g if you are not sure if the Oracle database sr server you want to connect to communicates on port 1521 or Omme 2483 Alias Oracle 1521 Open the scanner dialog with the Port Scanner button Type the ee 15258 name of the IP address of the database server in the Host field o s lorseus2s Specify the port range to scan with the Start Port and the End Port ss fields For most of the connectors the current configuration host 25t 52 072m Port 1522
9. or executing queries Whenever a value is set to mr zero the defaults of the driver are used for the ouwtmear 02 respective parameter Bookmarks Settings General Display Appearance Editor Drivers Plugins Software Update Connections History size 50 Note The settings of the time limit parameters are supported by a few drivers only Misc Allow execution of selected text range im SQL statement editor C Show tip of the day on startup 10 1 2 Bookmarks With the history size option you define the maximum number of bookmarks in the history list If the lists size exceeds this value the oldest entry will be removed when a new bookmark gets inserted 10 1 3 Misc Use the option execution of selected text range in SQL statement editor to control whether a selected text range can be executed provided that a selection exists instead of the whole text If this option is deactivated statements are always executed completely no matter whether a selection exists or not Select the Show the tip of the day option to display the tip of the day window on application start 10 2 Display 10 2 1 Desktop Use this component to configure the desktop The visibility of the windows bar below the tool bar can be controlled with the show windows bar option Changes applied to this setting only take effect after a restart of SQL Developer The show window contents while dragging option determines whether a window w
10. tab as spaces option Activate the support drag and drop option to enable text copy and move operations with the mouse 10 4 4 Display General Display Ppearance Editor Drivers Plugins Software Update a Selection of the Look and Feel Look and Feel Name System Look and Feel Standard v _ Decorate title bars and borders of windows requires restart Preview File Edit Misc Table A Red v de Colors Numbers One re Two y lt Da Check button 2 Radio button 1 000 Textfield General Display Appearance Editor Drivers Plugins Software Update Font Name Lucida Console size 126 Caret Options Shape Vertical line Y Caret blinks Automatic indent Insert tab as spaces O Support Drag and Drop Display M Character w show folder name occurrences excluding system folders SELECT fld name AS folder_name E COUNT FROM folders f1d only accept system folders WHERE lower f1d name LIKE system OR fld id lt 1000 f1d name GROUP BY An example statement shows the current color scheme used for syntax highlighting in editor windows Select a syntax element from the dropdown list and press the attached button to change the color for a certain element 34 44 SQL Developer User Manual 10 5 Drivers The Drivers tab shows a tree with all registered driver libraries SQL Developer can use for estab
11. tree node 14 44 SQL Developer User Manual 4 2 1 Quick Browse This function is used for the quick creation of simple SQL queries Select a table or a view from the database navigator and perform the function to open a new editor window for single SQL statements The function initializes the text input area with a SELECT statement for the selected relation You can execute the query as usual 4 2 2 Extended Quick Browse The extended quick browse function provides a simple way to create joined queries on tables Select a table from the database navigator and perform the function to open the query builder dialog Extended quick browse Tables Table columns re a C ACCESS _CONTROL_LIST ACL_UGR_FK C A GLOBAL_ACCESS_ CONTROL GCL_UGR_FK E UGR_USERS UU_UGR_FK gs CREATION_DATE E E USER_GROUPS UU_UGR_FK EM SPECIAL_GROUP_TYPE Fs ME WELL_KNOWN_PERSONS UU_WKP_FK E USER_GROUP_GROUPS UGG_MUG_FK O A USER_GROUP_GROUPS UGG_UG_FK Select all Deselect all The tree view on the left side shows the foreign key relations between the tables The root node represents the initially selected table The children of a node are those tables joined to the parent node by foreign key relations Subsidiary table entries are displayed with their table name followed by the foreign key name joining the table with the parent node A symbol with a yellow key indicates that a foreign key is defined by the parent
12. 00 v 6 Objects 2 Objects selected 43 44 SQL Developer User Manual 12 4 5 Sessions This extension shows all sessions running on the database for the currently selected adapter Use the Details button to show the last executed SQL command for the selected session With the Kill session button you can terminate the selected sessions The Refresh button re reads all information of all sessions 2 Sessions HADUTF8 NBG SOLYP DE system Use the Filter field to select a filter Peter eee _ criterion and specify a filter pattern In ACTIVE DEDICATED SYS SYSTEM HADDOCK H ACTIVE DEDICATED SYS SYSTEM HADDOCK HA the like field The filter works case ACTIVE DEDICATED SYS SYSTEM HADDOCK HA insensitive and supports the wildcard character Press the Enter key or the Refresh button to activate the filter ACTIVE DEDICATED SYS SYSTEM HADDOCK H ACTIVE DEDICATED SYS SYSTEM HADDOCK H ACTIVE DEDICATED SYS SYSTEM HADDOCK HA ACTIVE DEDICATED SYS SYSTEM HADDOCK HA ACTIVE DEDICATED SYS SYSTEM HADDOCK HA ACTIVE DEDICATED SYS ACTIVE DEDICATED SYS You can sort the table according to the ue pa fu Ps a values of a column by clicking the column s header with the mouse Another click on the same column header reverses the order Jim J ta Q3
13. 2005 12 27 11 so CHIMERA BIN EgrOT47xXSmGwtPIFTNHROG 0 GLOBAL_LANGS M TABLE MCMS 2005 12 27 11 51 CHIMERA BIN 9ITxIpxqRyCTeJAxbZqPfw 0 USE_PK INDEX mcms 2005 12 27 11 52 CHIMERA BIN SDgq IMSzeheo2Ub4d7pg 0 USAGES tase mcms 2005 12 27 11 53 CHIMERA BIN 1iYy7INHTA2pwHTWPdpKwa 0 MBW_MR_I E INDEX mcms 2005 12 27 11 54 CHIMERA 5YS_1L0000053872C00004 SYS_ILO000053872C00004 A LOB INDEX MCMS 2005 12 27 11 55 CHIMERA BIN CHs3dDO R1OLyQNUDTYX2w 0 MBW_PK A INDEX mcms 2005 12 27 11 56 CHIMERA 5YS_LOB0000053872C00004 I5Y5_LOB0000053872C00004 LOB MCMS 2005 12 27 11 57 CHIMERA BIN yf aLRgMTL 0JuszEoxXmTQ 0 MCMS_BASIC_WORKFLOW MCMS 2005 12 27 11 58 CHIMERA 5YS_ILOO000O54048C00002 5v5 _IL0000054048c00002 LOB INDEX MCMS 2005 12 27 11 59 CHIMERA 5YS_LOB0000054048C00002 SYS_LOBO000054048C00002 LOB MCMS 2005 12 27 11 60 CHIMERA BIN MNOSy7MBROG oyWSY42i24 0 CONTENTS_OLD E TABLE mcms 2005 12 27 11 61 CHIMERA BIN 4i1BQQOGIAMTIAXCTxsw 0 PAGE LANG PARTS OLD E TABLE mcms 2005 12 27 11 62 CHIMERA BIN PFqgBrquSQCGa3j8SaNMUA 0 ELEMENTS OLD E TABLE mcms 2005 12 27 11 _ 63 CHIMERA BIN SkqpaUG4TbekxuM4ljrvcw 0 WORDS_OLD tase mcms 2005 12 27 11 64 CHIMERA BIN zhPA7SqDSdOpSgVPl rw7A 0 PAGES_OLD Table mcms 2005 12 27 11 BIN OsuDkwwpQFaYGbF2KLelgw 0 5YS_C005870 E INDEX USERS 2005 1 1 20 00 BIN mgRCGCulTaaGUYudFxGPeA 0 TEST TABLE USERS 2005 11 20
14. 30 22 37 30 22 38 00 CPU busy 1 0 busy idle received sent errors Read Write Operations Processes Processes o N w h o o N o 22 37 30 22 38 00 22 38 30 22 37 30 22 38 00 22 38 30 read write errors total background sleeping runnable 12 2 4 Remote command shell This extension emulates a command shell on the database server The shell works synchronously The command control does not return until an executed command has finished Key input as wanted by some command s is being ignored Note The extension uses the SQL ca Remote command shell Haddock master sa Server function xp_cmdshell Members Be of the server role sysadmin have the A permission to execute this function by da default 13 11 974 656 gt g L O Verzeichnisise 7 659 655 168 Bytes frei C WINDOWS system32 gt 40 44 SQL Developer User Manual 12 3 MySQL extensions 12 3 1 Processes This extension shows all processes running on the database for the currently selected adapter Use the Details button to show the last executed SQL command for the selected process With the Kill process button you can terminate the selected processes The Refresh button re reads all information of all processes You can sort the table according to the values of a column by clicking the column s header with the mouse Another click on the same column header reverses the order 2 Processes MySQL r
15. 41 2 FOCCS SOS est anne da sta eee eee puede ad ae ces One ce use 41 2 AOracle exIenSiON usina retenida 42 220 AE XNA LR ca 42 A A A IN 42 1249 Oracle Texts tb eo o 43 124 R CYCIS Blusa en tente site es een 43 A a A E D SG eu 44 ZAS MONO EST A Ne tie en ee ati ie eee 44 3 44 SQL Developer User Manual 1 Preface SQL Developer is a powerful SQL client for querying and administration of databases The application has been completely implemented in Java and therefore runs on any platform supporting a Java Runtime Environment Version 1 4 or higher In principal SQL Developer supports any database providing a JDBC driver With the JDBC ODBC bridge driver from Sun you are can also connect to data sources via the ODBC driver SQL Developer homepage http saldeveloper solyp com Windows und Windows NT are trademarks or registered trademarks of Microsoft Corporation Sun Sun Microsystems Java JDK and Solaris are trademarks or registered trademarks of Sun Microsystems Inc All other trademarks or registered trademarks are property of their respective owners 4 44 SQL Developer User Manual 2 Getting Started This chapter describes how to get started with SQL Developer and what you should do before the first use 2 1 License Registration Right after having started SQL Developer the first time you MEP should register your license in the license dialog Only with a Welcome to SQL Developer registered license you can us
16. K_DEPTNG 1 Exported Key Triggers Segments A EMP TABLE PK_EMP IN i A Total size eE PLAN_TABLE E SALGRADE Views A Materialized views 0 Indexes p Procedures f Functions Packages Package Bodies Triggers 3 Sequences Types Af Type Bodies A Invalid Objects 3 8 Synonyms Gl EE EF 5 Open connection a Reopen connection D Close connection EMP HADUTF8 NBG SOLYP DE system SQL Statement SQL Script XI Bh iZ SELECT el EMPNO el ENAME E el JOB el MGR A el HIREDATE el SAL el COMM el DEPTNO dl DEPTNO dl DNAME E dl Loc FROM SCOTT EMP el INNER JOIN SCOTT DEPT dl ON d1 DEPTNO HI 7902 Deg EMPNO ENAME JOB 7369 5MITH CLERK 2 499 ALLEN SALESMAN 7521 WARD SALESMAN 7698 Feb 7698 Feb 7S6BIJONES MANAGER 7839 Apr 7654 MARTIN SALESMAN 7698 Sep 7698 BLAKE MANAGER SQL Statement L SQL Script Y Stored Program Editor tion O ms Fetch gt Quick browse 7839 Ma Ctrl M F782 CLARK MANAGER 7839 Jun cu Comores F3 7566 Apr 22 Extended quick browse F4 BB New A Edit Rename X Remove BB Be 00 Libraries EL Database Links SH Mit HADUTF8 NBG SOLYP DE system Oracle Mi Compile Enable Disable E Import table D Copy identifier Fe Copy te
17. R child nodes of each schema node show a p TEE Name OTPUSG_CONTEXT_ i i I i E ec ce mer S 0 Table schema CHIMERA detailed information about indexes nee A a sections stop word lists and z u Table key TYPE PN_ID PUSG_NA preferences For indexes there are akc enon nee Wa Pree 17 ndexed documents 0 additional functions available for ri ara synchronization optimization and E Status INDEXED 2 OTPUSG_LEXER Last error a CTXSYS Error text gh DEMOMCMS1 dd KGAL MCMSSOLI dd Swi a SPD dl WKSYS recreation The Refresh button re reads all Information in the tree E EE E E EE Synchronize Optimize fast Optimize full Rebuild 12 4 4 Recycle Bin Since Oracle 10g database objects can be deleted by moving them to the recycle bin With this extension you get access to the recycle bin of the current user or all users if you have sufficient privileges E Recycle Bin HAWKUTF8 system x V Show all recycle bins Filter No filter v like et SES Owner Recycle Bin Name Original Name Operation Type Tablespace Created 46 CHIMERA BIN KRSH14gzTma06t0IR7KAFO 0 PAG_MM_PER_IDx DROP INDEX mcms 2005 12 27 11 4 47 CHIMERA BIN IyInLp cRiqUYbm6 SmaEeg 0 PAG_IF_PK DROP E INDEX mcms 2005 12 27 11 48 CHIMERA BINSUAKkKQESIQg62YsvdcPozrg 0 PAGES DROP tase mcms 2005 12 27 11 RES CHER BINSFNWLL7ESQxXKUtDODJowesA 0 GLELNG_PK E INDEX MCMS
18. SQL Developer User Manual Version 2 2 0 Copyright Jan Borchers 2000 2006 All rights reserved SQL Developer User Manual Table Of Contents Mr PROT ACC a CR Sd Usine ad se Due nn e ne aan net den ans lcala 4 2 Getting Bro 21 a LEO na 5 2 1 License REGIS ITALIENS An sine io tie ie 5 2 2 Configuring Database Drivers ns 5 20 ESTAIS MN AS a te 6 S DESKTOP PR EA ica 7 A A ne ne a a 8 A A LE IA 8 A A ee vee ee eee ee nee er 9 oS el PONG ax I gt et ree te 10 SANNO OW esse cece a a telat tata salad 10 CL ne EAEE PEE E E E EET E E ane ne ee AO gr Te ETTE 10 So A nan a a E E EE 11 3 0 MDI WVINOOW AT A ecran a ee une nt tee oca 11 324 OUTDUL WVINOOWE SES an A 11 DAtaDASe Navid lO Feist dla as 12 a o E PI E PU OE E a ee Sane eter et EA A EA eo ree Ree nee oat anne ee 13 A2 Command Seke tail ea ln de oi 14 LANA 15 4 2 2 Extended QUICK BrOW Se cies SR os Eon Lo 15 5 Connection Dial tenons trs esse aa a a aaia 16 5 HAS CONCOURS ice esla diia fou 17 52 PO SCANS ni en NT a MN fe Rd ne unes 17 5 3 Oracle CONN ClOr e ain de cone Seca doc in de tte sud 18 5 4 Microsoft SQL Server Connector iii iiieiieecerceeeeererencececeeeneeeneeueee 18 5 5 IBMIDB 2 CONNMECIO Na dense tan mn cames ne cd doc ciel 19 5 6 Firebird ONNeCIOP A a a eh De a ler de ice et ce 19 57 ODBC CONAECIOR sevi a NI le le 19 6 SOs e N o S di idea 20 6 statement Edil ticas 21 Gil l BLOB VICWECR tas ces E EA A lei ce te TT 21 O2 GROB VIGNES e de Ne
19. SQLD 88 KB Feb 6 2006 1 56 15 AM C Projekte jb SQLD 17 KB Feb 6 2006 1 56 19 AM C Projekte jb SQLD 83 KB Feb 6 2006 1 56 20 AM C Projekte jb SQLD 8208 Bytes Feb 6 2006 1 56 20 AM C Projekte jb SQLD 46 KB Feb 6 2006 1 56 21 AM C Projekte jbiSQLD 38 KB Feb 6 2006 1 56 21 AM C Projekte jb SQLD 69 KB Feb 6 2006 1 56 25 AM C Projekte jbiSQLD 97 KB Feb 6 2006 1 56 23 AM C Projekte jb SQLD 33 KB Feb 6 2006 1 56 24 AM C Projekteljb SQLD 46 KB Feb 6 2006 1 56 24 AM C Projekte jb SQLD 286 KB Feb 6 2006 1 56 27 AM C Projekte jbiSQLD 29 KB Feb 6 2006 1 56 27 AM C Projekte jbiSQLD 117 KB Feb 6 2006 1 56 30 AM C Projektetjbi SQLD 32 KB Feb 6 2006 1 56 32 AM C Projekte jb SQLD 936 KB Feb 6 2006 1 56 36 AM C Projekte jbiSQLD 10211 Bytes Feb 6 2006 1 56 37 AM C Projekte jb SQLD 57 KB Feb 6 2006 1 56 38 AM C Projekte jb SQLD 69 KB Feb 6 2006 1 56 39 AM C Projekte jb SQLD 32 KB Feb 6 2006 1 56 40 AM C Projekte jb SQLD 91 KB Feb 6 2006 1 56 41 AM C Projekteljb SQLD Size gt 35 44 SQL Developer User Manual 11 Tip of the day After the first start of SQL Developer a dialog opens automatically showing various tips explaining how to work with SQL Developer Press the Next Tip button to change to the next tip You can open the dialog manually through the Help menu and the Tip of the day command Use the Settings dialog to activate or deactivate the automatic display on application start Tip of th
20. SS_CONTROL_LIST ACL_ALLOWED_TO has been removed 9 Foreign key ACCESS_CONTROL_LIST ACL_PAG_FK has changed Primary key table has changed PAGE_NODES PAGES Primary key name has changed PN_PK PAG_IF_PK Columns have changed O Table AUXILIARY_PAGES has been added E 9 Foreign key BINARY_DATA BIN_PAG_FK has changed Primary key table has changed PAGE_NODES PAGES Primary key name has changed PN_PK PAG_IF_PK Columns have changed A Index BINARY_DATA MCMS_INTMED_BIN_DATA has been added Index BINARY_DATA MCMS_INTMED_BIN_NAME has been added Trigger ORATXT_BIN_DELETE_TRG on BINARY_DATA has been removed Trigger ORATXT_BIN_INSERT_TRG on BINARY_DATA has been removed Trigger ORATXT_BIN_UPDATE_TRG on BINARY_DATA has been removed Foreign key BINARY_USAGES BINUSE_USE_FK has been added Table CONTENTS has been added Table DR MCMS_INTMED_BIN_DATA I has been added Table au 5500500050 37 44 SQL Developer User Manual 12 1 2 Dissolve dependencies This extension retrieves the relational dependencies between tables and views of a catalog or schema The use cases for this function include the initial data loading into or the complete data removal from the tables of a database without relational constraint violations Select the adapter and catalog or schema to examine as the source After selecting a source all accessible tables and views are displayed in the objects list Now you can select the objects to an
21. The database navigator shows all connected databases in a tree view and provides access to single database objects like tables views and users Grouping tree nodes are rendered bold Tables Views etc Which database objects are available in detail depends on the connected database The component can be moved within the desktop by using the tab on the upper border Use the tool bar of the window to call often used functions for the database navigator You can access the complete set of functions via the context menu right mouse button At the bottom border a status bar shows the currently selected path in the tree Database Navigator 1 d 4 fa LJ fal EX aa 4 Databases x a E 2 4 HADUTFS NBG SOLYP DE system Oracle E a Schemas schema ce 8 PUBLIC iy ANONYMOUS CHIMERA BEHE HEHHEHE H ME EEE H H i HH H ee ee Ee ee FA Tables Views A Materialized views Indexes p Procedures f Functions Packages D INTMED_SYNCHRO_OPTIMIZE 50 3 x Routines pl DATA_PRODUCER in rowid infout clob pl PUSG_DELETE in varchar2 in number in nur p PUSG_INSERT_UPDATE fin varchar2 in numb E 27 Dependencies CA PAGE_USAGES LB STANDARD a ve Package Bodies Triggers A Sequences 39 Types 2 Type Bodies amp Invalid Objects 3 8 Synonyms Libraries Database Links oie CTXSYS Users User Roles 88 User System Privileges 28 User Object P
22. a en ace 22 6 13 Commands Edito ati idas 22 6124 GOMMAnas eu ii 23 6 2 OCN PEE a 24 2 Olan NS reve A A Ea Eaa 24 653 Sred Pro0ram ECHO insti tii de 26 63 Tt COMMIMANG S aniston 26 F BOOKMAIKS cui a ee ee eee ese eee eee ene 27 7 l COMMANAS riales 27 8 Diagram Edito iia 29 8 COMPONEN Sii ld 29 Sab DISC NS ctas poor coito Ona 29 AO A A ein eee ee 29 Sa Dad Amn VIOL 29 A e A OOO A RAT Cl CD D ne teats 30 8 21 IMPOR O Sus te ter et teens eue ac 31 9 Database Ito iii nn a eS 32 10 SEINS cou donnes a benne adecco dead en ee 33 MS I a a tn settee ao no CN di ee le 33 VO A RE tend liter neta tet a nn ent And 33 10 12 DOOKU KS ee na ete eee cdad 33 SQL Developer User Manual MOET SNS O e tech aeds 33 10 2 DISP IV entend nono nn on E 33 NO ES SIO acts atin sates ee nt ee ne te en tn no nl 33 TOS APPANNA ride 34 103 LOOK ANG Fee lunar A a ited thaatTinctaes 34 10 2 O a A 34 TOA CO TN 34 A A 34 OR CAO A 34 OA e lt O ea 34 TOA ADISA ES RS rai iia 34 TO DANS o de D a gece cnet nge ete 35 TOS na LD LE ER PS 35 WD TD OU ING da 36 12 oa fe 9 ee di ee ee eo a ce eee 37 121 Standard extens ONS ES initia cease und lin ee de 37 12 11 Gatalog Schema Compans ON esnie eea ld 37 12 1 2 DISSOIVE GEDPENGENGICS ci ias 38 12 2 Microsoft SQL Server extensions iiiiiiiiuiererreeeeerrereceecereeeseee 39 1222 RN O A IT 39 12 2 2 IR TOCOSSO Sii iodo add 39 TARIMA AA A A 40 1224 hemote command Sell aiii Anar idee 40 12 35 MY SOUL CxS SIONS ti
23. abase as single statements The result of each statement is shown in the output window You can use three different symbols to separate statements in a script e Using the keyword GO Place the keyword at the beginning of a new line e The semicolon The terminator must be placed after a statement at the end of a line Note The processing of this symbol must be activated in the tool bar The processing is turned off by default e The slash The terminator must be placed at the beginning of a new line Note The processing of this symbol must be activated in the tool bar The processing is turned on by default SQL Editor 2 HADUTF8 NBG SOLYP DE scott Statement SQL SQL Script GGDUB2 7 2 1 6 update emp entries update emp set where d insert 6 2 1 Commands Skip to start Skip back Execute Single step Skip next Skip to end N Enable semicolon terminator Enable slash terminator deptno 102 eptno 101 emp entry empno for department 101 30 1 Modified Insert Places the text caret at the start of the script Moves the text caret to the start of the previous statement Executes the script beginning with the current statement up to the last statement Executes the statement at the current text caret position only Moves the text caret to the start of the next statement Places the text caret at the end of the script Turns the proce
24. alyze their dependencies for Press the Next button to start the analysis popup window informs about the progress The result will displayed in multiple variants The dentifiers tab shows a list of all involved objects Depending on the selected sort option dependent objects are either placed on the top delete semantics or at the bottom insert semantics of the list The Delete Script tab shows a complete SQL script to delete all data from the tables selected for the analysis For execution copy the script to the clipboard and paste it to a new or an existing editor script window Dissolve dependencies Source Adapter E HADUTF8 NBG SOLYP DE system Catalog Schema CHIMERA Objects m CHIMERA ACCESS_CONTROL_LIST m CHIMERA ALLOWED_ELEMENT_TYPES m CHIMERA ALLOWED_SUB_PAGES E CHIMERA BINARY_DATA CHIMERA BINSRY_TERMS E CHIMERA BINARY_USAGES A CHIMERA COMPATIBILITY E CHIMERA DA OTPUSG_CONTEXT_1 1 E CHIMERA DA OTPUSG_CONTEXT_I K E CHIMERA DASOTPUSG_CONTEXT_I N E CHIMERA DA OTPUSG_CONTEXT_I A mi CHIMERA ELEMENT_TYPES m CHIMERA GLOBAL_ACCESS_CONTROL E CHIMERA IDX_DEFINITIONS E CHIMERA IDX_VALUES m CHIMERA LANGS mi CHIMERA LINK_TERMS m CHIMERA LINKS CHIMERA MCMS_BASIC_ WORKFLOW E CHIMERA MCMS_PRIVS ASA MI Dissolve dependencies Identifiers DELETE Script Sort Dependent objects at start DELETE semantics Dependent objects at end INSERT semantics
25. ar C install database jTDS jtds 1 1 dist firs pbclient46 jar C Programme pointbase 4_6ilib E3 firebirdsql Full jar C install database Firebird JDBC FirebirdSQL 1 5 0Bete ifs jconn2 jar C Programme Sybase Shared jConnect 5_5 classes firs mkjdbc jar C install database Mckoi mekoil 0 2 2 postgresql 8 0 310 jdbc3 jar C Projekte jb SQLDeveloper HEAD workspa firs sapdbc jar C Programme sdb programs runtime jar firs ijdbc jar C Programme CA Ingres II ingres lib ES mimidbc3 jar C ProgrammeMimerSQL9 2 E3 derbyclient jar C ProgrammeiDerby lib Settings General Display Appearance Editor Drivers Plugins Software Update 7 Display of all registered plugins To install a new plugin copy the plugin library into the Y plugins folder in the installation directory of the application Plugins ES Name basicprovider jar 9 firebirdprovider jar Bw ibmcloudscapeprovider jar 3 ibmdb2provider jar NA ibminformixprovider jar 0 ingresprovider jar W mckoiprovider jar B mimersalprovider jar D msaccessprovider jar WD msdbaseprovider jar W W msexcelprovider jar NA mssqlserverprovider jar mstextprovider jar 3 mysqlprovider jar a odbcprovider jar Uy oracleprovider jar D pervasiveprovider jar pointbaseprovider jar Na postgresqlprovider jar 3 sqlbaseprovider jar 4 sybaseasaprovider jar Last modified Path 666 KB Feb 6 2006 1 56 12 AM C Projekte jb
26. comments the selected lines of an SQL statement Converts the selected text range to upper case characters Example foo_bar FOO BAR Converts the selected text range to lower case characters Example FOO _ BAR foo bar Converts SQL identifier within the selected text range to mixed case identifiers Example FOO BAR fooBar Converts mixed case identifier within the selected text range to SQL identifiers Example fooBar FOO BAR Encloses the complete or the selected text range in quotes Removes the quotes from the complete or the selected text range Opens the char map for input of special Unicode characters Displays and allows the change of the text encoding for the active editor window The encoding is determined automatically when opening a file The selected encoding is used for all save operations 9 44 SQL Developer User Manual 3 1 3 Extras ti Database info Catalog Schema Comparison 74 Dissolve dependencies lt Extensions gt Settings 3 1 4 Window Cascade Tile vertical M Tile horizontal f Close all lt Windows gt 3 1 5 Help j Tip of the day License 3 Search for updates a SQL Developer Homepage About SQL Developer q Opens the Database info dialog Opens the standard extension for Catalog Schema Comparison Opens the standard extension for dependencies Dissolving At this position SQL Developer provides
27. e all functions of SQL Developer ero T you dorit have aso yet peo vat the SQL Developer homepage to get an evaluation license A A or to purchase a permanent license First save your SQL Developer license to your computer To rte avoid unauthorized access to your license you should copy the A O license to your personal user directory la Paste license key Select the License item in the Help menu to open the registration dialog Copy your license key and paste it into the License key field in the lower half of the dialog After this confirm with OK SQL Developer is registered now and all functions are available 2 2 Configuring Database Drivers To access a database SQL Developer must have a suitable JDBC driver installed Usually JDBC drivers for a database can be downloaded from the internet site of the database vendor for free In most cases the driver files have the extender JAR Java Archive or ZIP mainly older drivers Select the Settings item from the Extras menu BE Click on the Dr iver S tab General Display Appearance Editor Drivers Plugins Software Update py Registration of database driver archives To register a new driver add the driver library provided by the vendor of your database to the list below This tab shows all drivers currently available W It h t h e A dd b u tto n yo u ca n O D e n th e fi e E ojdbc14 jar C YProjekteljb 5QLDeveloper HEAD workspacelProjectiDriver A ef oracle
28. e day Y Did you know You can execute a portion of query in the Single SQL Editor by selecting a part of the query text and pressing the F9 key This feature can be turned on and offin the Extras Settings dialog 36 44 SQL Developer User Manual 12 Extensions SQL Developer comes with various extensions providing general functions and vendor specific functions The extensions are accessible through the Extras menu 12 1 Standard extensions 12 1 1 Catalog Schema Comparison With this extension you can compare the table and view structure of two catalogs or schemas The 5 Catalog schema comparison Left comparison always compares a left and a right side Adapter HAWKUTES system Catalog Schema P CHIMERA For each side select an adapter and a catalog or TA IQ SC h ema Adapter HAWKUTFS system Catalog Schema 3 SOLD Use the options panel to control the properties to compare Options A Tables El View ES Columns x Routines Ignore case in identifiers Press Start to begin with the comparison The result V Ignore automatically generated objects will be displayed as a detailed text report ER Catalog schema comparison CHIMERA SOLD 5 41 Catalog schema comparison Feb 12 2006 10 47 18 PM Left HAWKUTF8 system CHIMERA Right HAWKUTF8 system SQLD Tables A amp column ACCESS_CONTROL_LIST ACL_ALLOWED_FROM has been removed A amp column ACCE
29. er The CLOB viewer displays textual content and supports unformatted text and XML If the current text is XML encoded the viewer automatically changes to the XML view mode with syntax highlighting You can format a XML content for easier reading by using the function from the tool bar aaa a o Klire linkedImageReference xnlns A liz attp siwww solyp com schema editor linkedimagereference xnlns lir http siuww solyp com schema editor linkedimagereferencetype gt lt lir imageReference xulns lir http siwww solyp com schema editor linkedimagereferencetype binaryld 2648 gt lt lir imageMap xulns lir http siwww solyp com schema editor linkedimagereferencetype gt lt im shape xblns im http siwww solyp com schema editor imagemaptype type polygon name Das Ei des Kolumbus coordinates 179 77 200 77 217 92 238 130 211 126 204 130 202 161 209 167 254 180 257 208 255 237 239 269 221 287 202 293 196 277 181 271 160 275 157 284 159 293 141 282 122 260 112 220 111 189 122 159 140 119 158 92 gt lt sh emptyLinkInternal xmins sh http siuwu s0lyp com schema editor shapetype pageld 2964 gt xnlns in http sivwuw solyp com schema editor imagemaptype CLOB viewer with XML syntax highlighting 6 1 3 Commands Editor 4 gt Execute Commit Rollback Fetch all COUNT Export data Copy bookmark Executes the statement Sends a COMMIT command to the database and confir
30. es Keywords Support Property Value Supports transactions Supports multiple transactions Supports read committed transactions Supports read uncommitted transactions Supports repeatable read transactions Supports serializable transactions Default transaction isolation Data definition causes transaction commit Data definition ignored in transactions Supports stored procedures Supports minimum SQL grammar Supports core SQL grammar Supports extended SQL grammar Supports ANSI92 entry level SQL Supports ANSI92 intermediate SQL Supports ANSI92 full SQL All procedures are callable All tables are selectable Max row size bytes Does max row size include blobs Extra name characters H Identifier quote string Procedure term procedure Search string escape i Max catalog name length chars 0 Max char literal length chars 2000 Max cursor name length chars 0 Max index length bytes 0 Max procedure name length chars 30 Max row size bytes 2000 000000 d committed Q e 00 RS el elt t 32 44 SQL Developer User Manual 10 Settings With the settings dialog you can configure all important application parameters The dialog is accessible through the Extras menu and the Settings command 10 1 General 10 1 1 Connection Here you can specify a global time limit used by a driver when connecting to a database
31. g aborted by time out 5 Close connection Closes the currently selected connection PP SQL Statement Opens a new editor window for single SQL statements on the current connection 2 SQL Script Opens a new editor window for SQL scripts on the current connection 8 gt Stored Program Editor Opens a new editor window for stored procedures on the current connection gt Quick browse Opens a new editor window for single SQL statements on the current connection and presets the input area with a SELECT statement for the selected table or view 3 Extended quick browse Opens a dialog for the fast creation of joined queries on tables 1 New Creates a new database object as a child of the selected object type a Edit Modifies the selected database object Rename Modifies the name of the selected database object gt Remove Removes the selected database objects lt Extensions gt At this position SQL Developer provides access to database specific extensions where applicable Extract DDL Creates a DDL script for all selected database objects 4 Copy identifier Copies the physical identifiers of the selected database objects to the clipboard 3 Copy text Copies the identifiers of the selected database objects as shown in the database navigator to the clipboard Collapse subtree Collapses the subtree of the selected database object on all levels Refresh node Refreshes all children of the selected
32. iagram objects graphically Select one or more objects from the view to perform a function on them The selection is always synchronized with the 29 44 SQL Developer User Manual selection of the object list selected object is displayed with a dashed selection border and multiple selection handles To select multiple objects click on the background of the diagram view with the mouse and hold down the mouse button By dragging the mouse cursor you span a rubber band you can use to include the objects to select When you release the mouse button the objects inside the rubber band bounds get selected Hold down the Shift key during selection to add new objects to the existing selection Hold down the Ctrl key to invert the selection state Selected objects will be deselected and vice versa To move an object click inside the object s bounds hold the mouse button and drag the mouse cursor To change the size of an object click on a selection handle of the object and drag it to the desired position You can add additional vertexes to a connector line between two objects e g to create right angled connectors Hold down the Shift key and right click on the line where the new vertex should be added An existing vertex can also be removed by right clicking its selection handle 8 2 Commands Import objects Imports tables and views into the current diagram Delete Removes the selected objects from the diagram EF Select a
33. ional references into the current diagram If there is no open database connection yet at first the connection dialog will be displayed where you can select a connection profile or create a new one Next the dialog for importing objects is shown Select a database and a catalog schema as the source containing the objects to import After source selection all tables and views available for import are shown in the lower part of the dialog If an objects with the same name already exists in the diagram its entry is displayed in bold style Now select all objects to be import and confirm with OK If you select objects that already exist in the diagram these objects will be updated but keep their position size and style Catalog Schema Import Source Adepter ES HADUTFS NEG SOLYP DE system Catalog Schema a SCOTT Objects a g Tables aoe EE w Bestelldetails 238 Boestellungen t CA Kategorien fee Kunden A Lieferanten E Views Alphabetische Artikelliste Artikel nach Kategorie 22 Artikel ber Durchschnittspreis E Bestelldetails erweitert Rechnungen Ums tze nach Kategorie Ums tze nach Kategorie F r 1997 31 44 SQL Developer User Manual 9 Database Info The Database Info dialog shows information about the currently selected database connection like connection parameters structure keywords etc Database info HADUTF8 NBG SOLYP DE scott General Structure Functions Typ
34. ithin the application s desktop is drawn continuously when being dragged Use the scrollable desktop option to show horizontal and vertical scroll bars at the right and bottom border of the desktop whenever a child window exceeds the bounds of the desktop 33 44 SQL Developer User Manual 10 3 Appearance 10 3 1 Look and Feel The Look and Feel denotes the look and the behavior of the user interface Here you can select the look and feel SQL Developer should use The System Look and Feel looks like the actual user interface of your operating system and is used by default Some Look and Feels also support to decorate title bars and borders of windows with the look and feel s style e g the Metal Look and Feel Note This option requires a restart of the application to take effect 10 3 2 Preview The preview provides a collection of controls that are changing their look according to the currently selected Look and Feel 10 4 Editor 10 4 1 Font Here you can configure the family name and size of the font to be used in editor windows 10 4 2 Caret You can select between three different shapes for the text caret insertion mark in text editors Vertical line horizontal line or hollow 10 4 3 Options When the automatic indent option is selected the text caret is placed with the same indent as the line before after performing a carriage return To insert blank characters instead of a tab character activate the insert
35. jdbc driver OracleDriver selection dialog for driver files Select the a ef oracle jdbc OracleDriver mysql connector java 3 1 10 bin jar C install database mySQL jConnectt previously downloaded driver and confirm with OK Now the driver is shown in the tree and can be used Drivers jtds 1 1 jar C install database jTDS jtds 1 1 dist ES pbclient46 jar C Programme pointbase 4_6 lib E firebirdsql Full jar C install database Firebird JDBC FirebirdSQL 1 5 OBeta CS jconn2 jar C Programme Sybase Shared jConnect 5_5 classes Ed mkjdbc jar C install database Mcko mckoit 0 2 postgresal 8 0 310 jdbc3 jar C Projekte jb SQLDeveloper HEAD workspa firs sapdbc jar C Programme sdb iprogramsiruntimejar lis ijdbc jar C Programme CA Ingres II ingres lib ES mimidbc3 jar C Programme MimerSQL9 2 E3 derbyclient jar C Programme Derby lib ee EE yee Be Be gt 9 44 SQL Developer User Manual 2 3 Establishing Connections Select the Open connection item from the File menu The connection dialog shows all available connectors arranged in tabs The Basic connector provides the most flexible sr way to establish a database connection At JE least you need to specify a driver class name and a URL Details on both parameters can be sx acess ps2 dbase Exel Freba Ingres Mekai mimer sa ms found in the vendor s driver manual Driver x
36. ked Blocking Database Ess CPU Physical 1 0 of all processes M o Ti no no 21742 dbo 0 master 3465 0 master 5716340 master 5710031 0 master master master master master master master master master master master Use the Filter field to select a filter criterion and specify a filter pattern in the like field The filter works case insensitive and supports the wildcard character Press the Enter key or the Refresh button to activate the filter o Les fa Ovo o O0 O0 G G a co r Ow oo 000 0000 0000 GGO AIAN WIN COO oO 000000 9 0010 Ol OT EMP NINININI N O NIN O uojo 0 0 0 0 0 0 0 0 0 0 a Oo You can sort the table according to the values of a column by clicking the column s header with the mouse Another click on the same column header reverses the order 39 44 SQL Developer User Manual 12 2 3 Monitor The Monitor extension provides a graphical user interface for the internal SQL Server monitor function lf the auto refresh option is checked new measured values are recorded repeatedly after the selected period 5 seconds to 10 minutes has elapsed Note The extension uses the SQL Server function so monitor Members of the server role sysadmin have the permission to execute this function by default 2 Monitor HAWKFISH Northwind sa Load Packets 0 22 37 30 22 38 00 22 38
37. lishing connections to a database Each entry on the first tree level shows a library name and its file path The child entries on the second level show information about the driver classes provided by the library When establishing a connection the tree is searched from top down for the required driver You can modify the loading priority of a driver by moving its entry using the Up and Down buttons lf a driver library can not be accessed e g because the file has been removed the library icon is marked with a little red symbol Note If you replace a driver library with a new version there can occur problems loading the new driver In this case you should restart SQL Developer to ensure that the new driver will be loaded instead of the old one 10 6 Plugins The Plugins tab shows all currently loaded auxiliary modules from the plugins folder in the SQL Developer installation directory Settings General Display Appearance Editor Drivers Plugins Software Update yA Registration of database driver archives To register a new driver add the driver library E provided by the vendor of your database to the list below Drivers E E E E E i El Ge ojdbc14 jar C Projekte jb SQLDeveloper HEAD workspace Project Driver ef oracle jdbc driver OracleDriver ef oracle jdbc OracleDriver E3 mysql connector java 3 1 10 bin jar C install database mySQL jConnectt E itds 1 1 j
38. ll Selects all objects in the diagram Invert selection Inverts the selection state of all objects Grid on off Toggles the grid display t Snap to grid Toggles the snap to grid behavior Preferred size Changes the size of all selected objects to their preferred size st Automatic layout Automatically applies a layout to all diagram objects t To front Moves all selected objects into the foreground 1 To back Moves all selected objects into the background Align shapes Aligns the positions of all selected shapes against each other Foreground color Changes the foreground color of all selected objects Es Line color Changes the line color of all selected objects P Background color Changes the background color of all selected objects Y Zoomin Increases the zoom factor of the view Zoom out Decreases the zoom factor of the view 30 44 SQL Developer User Manual Sets the zoom factor to the specified percentage value Allowed values range from 1 to 1000 C gt Fit to selection Zooms the area of selected objects gt Fit to window Changes the zoom factor that all objects fit into the visible region of the view gt Zoom 1 1 Sets the zoom factor to 1 ais Export as SVG Exports the diagram to file in SVG Scalable Vector Graphics format as Export as PNG Exports the diagram to file in PNG Portable Network Graphics format 8 2 1 Import objects This function imports tables and views including their bidirect
39. modal windows are displayed in the MDI Multiple Document Interface window area The window area itself is not movable within the desktop but you can arrange other movable components Database Navigator output window etc around The window bar is shown automatically at the upper border when a window has been opened Each new window is displayed in the bar in its own tab Click on the tabs to switch between the windows The window bar display shown or hidden can be configured in the settings dialog 3 4 Output Window The output window provides a tab for each database connection lf a connection produces output e g when executing a SQL script or if an error occurs it is shown in the output window tab for that connection 4 Output EH Database Microsoft SQL Server A Version 03 00 0760 9 Driver UDBC ODBC Bridge SQLSRV32 DLL Version 2 0001 03 85 1117 25 07 2005 12 15 59 Microsoft ODBC SQL Server Driver QL Server Invalid Objectname NorthvindBackup dbo CustomerDemographics SQL State 50002 Base table not found Error Code 208 CustomerTypeID CustomerDesc Haddock master sa mymimer sysadm iambicTimeAndExpense mdb localhost gotcha postgres The component can be moved within the desktop by using the tab on the upper border Use the tool bar or the context menu right mouse button to clear the protocol or to save it to a file 11 44 SQL Developer User Manual 4 Database Navigator
40. ms all pending changes Sends a ROLLBACK command to the database and discards all pending changes Usually SQL Developer reads the result set of a query in blocks on demand If this button is pressed all rows returned by the executed statement are fetched at once Retrieves the number of rows the current statement would affect Exports the data returned by a SELECT statements to the clipboard or to a file Creates a new bookmark from the current statement and copies it to the clipboard 22 44 SQL Developer User Manual 6 1 4 Commands Result Set H Copy Copies the selected cells of the table to the clipboard Copy column names Copies the names of the selected table columns to the clipboard 3 Copy WHERE clause Creates a WHERE clause from the selected cells of the table and copies it to the clipboard Adjust column width Adjusts all table columns to match the preferred width of based on header the cells in the table header Adjust column width Adjusts all table columns to match the preferred width of based on header data the cells in the table header and body HH Adjust column width Adjusts all table columns to match the preferred width of based on data the cells in the table body 23 44 SQL Developer User Manual 6 2 Script Editor The Script Editor is used to execute scripts consisting of one or more statements When executing a script the content of the editor window is being parsed and sent to the dat
41. n a name address and port is used to preset the fields when the Sian dialog opens port can be specified with its Number or Peres alternatively with an Alias In the alias list you find a collection of ports of major databases Cancel Press the Scan button to start the scan The scanner tests the complete port range and shows for each port if its accessibility state and the response time 17 44 SQL Developer User Manual 5 3 Oracle Connector The Oracle connector supports connecting the server by specifying Host name or IP address Port and SID or a Net Service definition from a TNS Names file To use Net Service definitions you must specify a TNS a Names file providing the definitions Usually the file iS uosporsio means PEE installed together with an Oracle server or Oracle client onaseve in a subfolder of the Oracle Home directory in the path lt Oracle Home gt network admin Passwor Connect as Default Y In any case you must specify the user name of the Oracle schema and the password With the field came rx 3 Connect as you can choose if the user acts as a Standard user as Operator SYSOPER or as DBA SYSDBA The last two options are only applicable for the SYS user The name field is optional and enables you to enter a profile name manually If the field is left empty SQL Developer automatically generates a name for the connection For the driver
42. node referencing the primary key of the child node parent child n 1 red key indicates that a foreign key is defined by the child node table and references the primary key of the parent node parent child 1 n All checked tables are included in the SELECT clause of the statement to create You can determine the table columns to be included on the right side By default all columns of a checked table are selected When you confirm with OK a new editor window for SQL statements is opened and the text input area is initialized with the generated SELECT statement 15 44 SQL Developer User Manual 5 Connection Dialog The connection dialog is accessible through the EESTE File menu and the Open connection command Profle v Mew J _Delete For each new connection SQL Developer z p OPEC Oracle PointBase PostgreSQL SQL Base SOL Server Sybase 454 Text creates a profile that is displayed in the Access DB2 dBASE Excel Firebird Ingres Mckoi mimer SQL mysql dropdown list in the upper part of the dialog x When the user selects a stored profile the ue connector described by the profile gets selected rs and its fields are preset Name pie To create a new connection select a suitable __ name Value connector first All available connectors are displayed as tabs Except for the Basic connector the required drivers for a connector are predefined Press
43. oote localhost TLL Process ID User Host Database Command Time State Info root 127 0 0 1 3015 mysql Sleep LL 38 root 127 0 0 1 3020 mysql Sleep 2 3 99 root 127 0 0 1 3021 mysql Query y 12 root 127 0 0 1 3024 mems Sleep SHOW FULL PROCESSLIST Processes 41 44 SQL Developer User Manual 12 4 Oracle extensions 12 4 1 Explain Plan With the Explain Plan extension you can analyze the execution plan of a query Paste the statement to analyze from the clipboard into the SQL editor in the upper part of the dialog You can also load a statement from a file using the Open function You can specify an optional D for the statement to execute In this case the query will be stored with the ID in the plan table otherwise it will be stored as an anonymous query To build an execution plan Explain Plan HADUTF system you need a plan tabl e Plan Table SYSTEM PLAN_TABLE E Statement 1D Please ensure that a plan fe table exists before the first in See on d deptno e deptno attempt to build a plan If no such plan table exists SC CS you can create one by a Cost Owner Name Type Optimizer Rows using the Create button FES CHOOSE Use the Execute button AE tame access PUL 2 SCOTT EP us from the tool bar to analyze the statement The Execution plan will be displayed in a tree table in the lower part of the dialog 12 4 2 Jobs The Jobs e
44. rivileges Roles 28 Privileges iy Tablespaces 24 Rollback segments HF localhost sample2 pbpublic PointBase El Haddock master sa Microsoft SQL Server EAA mymimer sysadm Mimer SQL Engine iambicTimeAndExpense mdb ACCESS L 1 localhost gotcha postgres PostgreSQL v lt j HADUTFS NBG SOLYP DE system Oracle CHIMERA ORATXT_PUSG_IND gt 12 44 SQL Developer User Manual 4 1 Objects The following objects are a part of the database objects supported by SQL Developer The actual number of objects depends on the connected database Databases Root Schema Catalog User User group Table Temporary table View Materialized view Snapshot Table View column Table column with primary key AROABABReR S Table column with foreign key Table column with primary and foreign key Index Index column Function Procedure 28 Synonym Constraint Primary key constraint Foreign key constraint Unique key constraint Check constraint Trigger Sequence Generator B Library amp Tablespace amp Package Module Type Role 4 Invalid object 8 Privilege y Dependencies 13 44 SQL Developer User Manual 4 2 Commands Open connection Opens the connection dialog Reopen connection Closes the currently selected connection and opens it again With this function you can reactivate aborted connections e
45. s the server you want to establish a connection to Use the Database field to specify the physical name of the database to open or an alias name known by the server The fields User and Password define the authentication parameters 5 7 ODBC Connector DB2 server you Database pollux Host localhost Port 50010 Driver type IBM DB2 Network Driver User castor PESO er Name Firebird v Host localhost Port 3050 Database C Firebird examples EMPLOYEE FDB z Charset JNICODE_FSS User castor Password 44 Name v The ODBC connector has been invented for Windows systems to works with databases using the ODBC interface Open Database Connectivity Windows manages its data source names DSN in a text file named odbc ini in the Windows directory These names are used to create ODBC connections by name Before the first use of this connector specify the path of that file for your system in the ODBC ini field SQL Developer automatically extracts all registered data source names and shows them in the DSN field To create a connection select the desired entry in the DSN field Optionally you can also input a data source name manually ODBC DSN MyO dbcD atasourceN ame User castor Password PPFPPFP Name ODBC ni C WINDOWS ODBC INI The fields User and Password define the authentication parameters v 19 44 SQL Developer U
46. ser Manual 6 SQL Editors SQL Developer supports three kinds of SQL editors Statement script and procedure editors Each editor window has its own connection its own transaction and can perform Commit and Rollback commands An editor window always uses the current adapter shown in the dropdown list in the tool bar to create its connection After opening the editor you can use the Open menu item to load the content of a file into the editor The filename is automatically used for the editor s window title There are two ways to save the content of an editor window e lf the content has been loaded from a file or has already been saved to a file use the Save command from the File menu e Select the Save as command from the File menu if you have created a new content from the scratch or if you want to store the content with a new filename Above the input area of each editor window you find a tool bar providing all commands for that editor You can also use the context menu right mouse button to access these commands Note When closing an editor window a rollback is performed automatically on the connection All uncommitted changes will be discarded Each editor supports an undo and a redo function The undo function can be accessed by pressing Ctrl Z press Ctrl Y to redo text changes 20 44 SQL Developer User Manual 6 1 Statement Editor The Statement Editor is used to execute a single statement The content of the edi
47. splayed underneath the history In the lower part of the detail view you see the actual SQL statement of the bookmark Except for the modification date you can modify all fields in the detail view To apply your changes press the button at the bottom To execute the SQL statement of a bookmark copy the statement from the detail view to the clipboard and paste it into an opened SQL editor Alternatively you can directly drag the bookmark from the tree view into a SQL editor 7 1 1 Commands iw New bookmark Creates a new bookmark underneath the selected folder Fi New folder Creates a new folder underneath the selected folder Rename Renames the selected node bookmark or folder dt Cut Moves the selected node bookmark or folder to the clipboard y Copy Copies the selected node bookmark or folder to the clipboard Paste Pastes a bookmark or a folder from the clipboard x Delete Deletes the selected bookmark or the selected folder including all contained bookmarks and subsidiary folders t Move up Moves the selected node bookmark or folder within its siblings up by one position Move down Moves the selected node bookmark or folder within its 27 44 SQL Developer User Manual Split view vertically H Split view horizontally Show bookmarks only siblings down by one position Arranges the tree view in the upper and the detail view in the lower half Arranges the tree view in the left and the detail view in
48. ssing of the semicolon terminator on or off Processing is turned off by default Turns the processing of the slash terminator on or off Processing is turned on by default 24 44 SQL Developer User Manual Enable output echo Turns the output echo on or off If activated each statement is shown in the output window before it is sent to the database for execution Y Commit Sends the COMMIT command to the database and confirms all pending changes ta Rollback Sends the ROLLBACK command to the database and discards all pending changes 25 44 SQL Developer User Manual 6 3 Stored Program Editor The Stored Program Editor is used to edit stored procedures To compile a procedure the complete content of the editor window is sent to the database as one block s XSLPROCESSOR HADUTF8 NBG SOLYP DE scott PREATE OR REPLACE package SY5 xslprocessor authid current user as ft Processor interface type my TYPE Processor IS RECORD ID NUMBER NOT NULL 1 ft Stylesheet interface type ay TYPE Stylesheet I RECORD ID NUMBER NOT NULL lj fre Returns a new processor instance bye FUNCTION newProcessor RETURN Processor ptr Free XSL Processor oe PROCEDURE freeProcessorip Processor PA Transforms input XML document using given DOMDocument and stylesheet This function doesn t support lt code gt xsl output lt code gt To use xsl output use processxSL functions which accept s
49. the nfo button to show the information about the driver name driver class vendor URL and status If a required driver for the selected connector is not available this is shown by the status field You can add missing drivers directly from the connection dialog Use the Driver Settings button to add a new driver The opening dialog shows the Drivers tab of the Settings dialog After you have specified the parameters for the selected connector you can create a new connection by pressing the OK button 16 44 SQL Developer User Manual 5 1 Basic Connector The Basic connector is a universal connector creating connections with any JDBC driver AI other connectors are specialized connectors for certain databases Note If a specialized connector exists for your m database you should prefer that connector because ItS Dive Lonmsai eive configuration will be much easier PAL iebempsak focahhost3306 pola User root To create a connection with the Basic connector you Pt s have to specify at least a driver and a URL You can sasen S get both parameters from the driver documentation of nae Value the vendor Both fields are editable dropdown lists on providing preconfigured values you can use for various popular databases EE Name The parameters for user and password are required for the most databases also For this reason they are displayed as two additional fields The name field is
50. tor window is sent to the database at once SQL Editor 1 HADUTF8 NBG SOLYP DE scott Statement SQL SQL Script KI SRE INR select e ename e job A d dname from emp e left join dept d on d deptno e deptno El Modified Insert EIE pe ENAME JOB DNAME CLERK ACCOUNTING PRESIDENT ACCOUNTING MANAGER ACCOUNTING ANALYST RESEARCH CLERK RESEARCH lANALYST RESEARCH MANAGER RESEARCH CLERK RESEARCH 9 CLERK SALES an Le Carrera PTA f O ms execution 0 ms fetch The result is visualized as a table in the lower part of the editor window Each table cell displays a single value from the result set Because of their size LOBs Large OBjects are displayed partially or as a link CLOBs Character LOBs and BLOBs Binary LOBs are shown with their type name and size only To view the content of such an object select its table cell an click the arrow symbol shown within the cell 6 1 1 BLOB Viewer The BLOB viewer displays any kind of binary data in a combined hexadecimal and ASCII view Use the Save button from the tool bar to save the BLOB to your local computer lf the current BLOB is a picture you can view it by changing to the Image tab The supported formats are JPEG GIF and PNG For BLOBs with different format no picture is shown H Data Image Data Image A 0000 0000 47 49 46 38 39 61 C8 00 B4 00 F7 00 00 00 00 OO GIFS9a
51. tream output such as file or buffer my v fia inset 6 3 1 Commands Compile Compiles the procedure 26 44 SQL Developer User Manual 7 Bookmarks With the bookmarks component you easily manage Elx Dexs O frequently used queries and statements pee 3 2 Mpmsfs The component can be moved within the desktop by using en the tab on the upper border we A SELECT SCHEMAID TABLENAME Jul 23 2005 12 08 31 AM The component is divided into the tree view with all one ee TAA existing bookmarks and the detail view for a single M SELECT VIEWSCHEMAID VIEWID Jul 23 2005 12 06 22 AM bookmark Name User groups for a person Underneath the favorites folder you can manage your own PsP bookmarks and folders PA Las 2005 11 06 41 AM select scl cld id scl cld fs name The history folder always shows the latest executed sugl uge_group_type r sugul ugme prnc id queries and statements With the copy and paste functions aa E o you can move bookmarks from the history tO YOUN srm musrsirepes sts children sel I favorites Di join er user groups sugl on FF ai Select a bookmark to show all its information in the detail view The name is also used for displaying the bookmark in the tree For this reason the name should be as precise and short as possible to identify the bookmark The description is optional The modification date is managed automatically by the application and is only di
52. type to be used you can choose between the Thin driver recommended and the OCI driver The Thin driver does not require any special client installation the OCI driver is only available if you have an Oracle client installed 5 4 Microsoft SQL Server Connector The Microsoft SQL Server connector uses the JDBC EEC ODBC Bridge driver To establish connections YOU pass co need the Microsoft SQL Server ODBC driver to be Die loscyoec Bridge Driver v installed on your computer O With the fields Host name or IP address Port e default port is 1433 and Database name of the catalog you define the connection parameters The connector supports two different Drivers The ODBC JDBC bridge driver and the platform independent TDS driver The fields User and Password define the authentication parameters 18 44 SQL Developer User Manual 5 5 IBM DB2 Connector Use the fields Database Host name or IP address and Port to address the want to create a connection with The connector for IBM DB2 databases uses two different driver types to create connections The network driver and the application driver Press the nfo button in the connection dialog to test if the required is available The fields User and Password define the authentication parameters 5 6 Firebird Connector The Firebird connector has been developed for Firebird Version 1 5 With the fields Host name or IP address and Port you addres
53. xt Bookmarks C Projekte jb SOLDeveloper testdata sfsrepos sqlddm AYP Pax VDO gt se 4 m id lt We eg He Objects UT ORATXT_DUSG_SRC UM SFS_CATEGORIES LU SFS_CHILD_ACL_DEF O SFS_CHILDREN_DEF E SFS_DOCUMENT_BINARIES SFS_DOCUMENT_USAGE_STATE UN SFS_DOCUMENT_VERSIONS UM SFS_DOCUMENTS UM SFS_EXTERNAL_KEY DIN cee CYTENRIAI VEW variic 11 ge Oracle Oracle9i Release 9 2 0 1 0 Production Ctrl C JServer Release 9 2 0 1 0 Production 5 Oracle JDBC driver AS 20 1 0 2 0 Sa Collapse subtree Refresh node NumPad FS SCOTT EMP HADUTFS NBG SOLYP DE system 7 44 SQL Developer User Manual 3 1 Main Menu The main menu is located at the upper border of the application window The submenus and menu items of the main menu are described below 3 1 1 File Open connection Reopen connection y Close connection Save as New diagram El Open diagram Save diagram Save diagram as Opens the connection dialog Closes the currently selected connection and opens it again With this function you can reactivate aborted connections e g aborted by time out Closes the currently selected connection Shows a list of the most recently opened connections Reads a file into the active editor window This function gets available after an editor window has been opened for a connection Writes the content
54. xtension shows all jobs of the current user lf your user account has appropriate permissions you can also show all AJ Jobs of the database instance Press the Run button to run the selected Jobs HADUTF8 NBG SOLYP DE system job directly Use the Activate and Bax Y Show DBA jobs Filter No filter w like Deactivate buttons to start and stop a Job User LastDate This Date Net Date selected job With the Extract DDL TM Li a button you can generate a creation Da sr 2008280828470 EE MCMSSQLJ 2004 08 06 21 13 20 0 2004 08 06 21 14 20 0 script for the selected jobs The Refresh button re reads all information of all jobs Use the Filter field to select a filter criterion and specify a filter pattern in the like field The filter works case insensitive and supports the wildcard character Press the Enter key or the Refresh button to activate the filter You can sort the table according to the values of a column by clicking the column s header with the mouse Another click on the same column header reverses the order 42 44 SQL Developer User Manual 12 4 3 Oracle Text This extension shows information about Oracle Text a part of Oracle interMedia On the left side a tree shows all schemas that are visible to the current em Oracle Text HADUTF8 NBG SOLYP DE system i EX XH Index user and are using Oracle Text The arene eae RE

Download Pdf Manuals

image

Related Search

Related Contents

  CJ2H-CPU6@  Provision-ISR SA-8200N+ digital video recorder  Epson C I - 4 0 4 0 User's Manual  Fujitsu Presenter USB III  SP3200  Brake units manual  Smeg ST975 Instructions for Installation and Use  ASUSTOR USER GUIDE  Conditions générales d`utilisation option monétique TPE  

Copyright © All rights reserved.
Failed to retrieve file