User Manual - SQL Developer
Contents
1. driver required for a specialized connector is already aumens N available You can edit the Driver Settings directly mur vue 7 from the connection dialog to add missing drivers Click the OK button to confirm the settings for the current tab and to establish a new database connection 6 43 SQL Developer User Manual 3 Desktop The desktop of the application consists of the following components e a D pa 5 Main menu and tool Database Navigator bar Output window and Bookmarks MDI Multiple Document Interface window area Context menus 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 S E HADUTFS NEG SOLYP DE system v 72VIm NBA sl i3 Database Navigator A 2 emp E sfsrepos sqlddm PRIEEBRX t xp TT Gy OLAPSYS dy ORDPLUGINS eh ORDSYS Hy OSCAR ph OSCARZ Hy OSCARCTXAPP jy OUTLN 5d PM ie QS de Q5_ADM eh Q5_CB cede Q5_CBADM Q5 C5 te QS_ES dede Q5_05 de ey Q5_WS ce y RMAN SCOTT EE Tables E BONUS eE DEPT ou E Columns ff Indexes E Constraints amp Triggers Segments A PLAN_TABLE El SALGRADE Views Indexes p Procedu2. A 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 the right half Hides the detail view and shows the tree view only 28 43 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 LEERSE SEA lP Dix vi DD L 1 PERSON_ATTRIBUTES L PERSON_KEY_ATTRIBUTES L PERSON_KEY_VALUES LT PERSON_VALUES MA PERSONS M UGR_USERS PKV_AKA_FK I USER_GROUP_GROUPS LI USER_GROUP_KEY_ATTRIBUTES L L USER_GROUP_KEY_YALUES M USER_GROUPS M WELL_KNOVN_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 its 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
3. PROCEDURE freeProcessorip Processor PA Transforms input XML document using given DOMocument and stylesheet This function doesn t support lt code gt xsl output lt code gt To use xsl output use processxSL functions which accept stream output such as file or buffer v DE IE eeo 6 3 1 Commands Compile Compiles the procedure 26 43 SQL Developer User Manual 7 Bookmarks With the bookmarks component you easily manage frequently used queries and statements RF rr i Mpmsfs The component can be moved within the desktop by using N Ee the tab on the upper border Pii A SELECT SCHEMAID TABLENAME Jul 23 2005 12 08 31 AM The component is divided into the tree view with all Ra win ee existing bookmarks and the detail view for a single ete reer eielsey bookmark Name User groups For a person Underneath the favorites folder you can manage your own Peme bookmarks and folders Modified on Ju 13 2005 11 06 41 AM select scl cld id The history folder always shows the latest executed An P sugnl uqme prnc id queries and statements With the copy and paste functions ie mu you can move bookmarks from the history to YOUM sro musrsivepes sts children scl 7 inner join mpnsfslrepos sfs user groups sugl on sugl uY favorites gt Apply Select a bookmark to show all its information in the detail view The name is also used for displaying the book
4. name of the catalog you define the connection parameters Name The fields User and Password define the authentication parameters 18 43 SQL Developer User Manual 5 5 Firebird Connector The Firebird connector has been developed for Firebird Version 1 5 With the fields Host name or IP address and Port you address 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 6 ODBC Connector Firebird Host localhost Port 3050 Database C Firebird examples EMPLOYEE FDB 3 Charset UNICODE_FSS v User castor Password 444 Name 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 My0 dbcD atasourceN ame be Us
5. 23 O22 SiO A on le sa nue ete ne tee 24 a o alan lao ssa seu hacer q ne de ed ce et os ta 24 03o Ured Program Ed essare ae a ceed newsmen 26 0 53 L OCOMMANAS it lit 26 BOOKMArKS curia isa 27 ICONOS usura orina tddi diosa 21 9 Diagram EGON Re Re RS E 29 0 l C OMPONENES ia 29 SP Ps A 0 11216 6 LS een ne eee ee eer ee ee ee een nn 29 S LZ OVEIVIEW acted as O 29 ARA dr nee tie tacts ec dye Dany Daca viata ie See 29 OZ COMMANGS ER oia caido iii tie indie 30 0 21 IMPOR ODICCIS 23a cides Re Se ee ee iron 31 9 Database Info sn eo re one 32 TUN OS ee ere eee eet ee ee eee eee 33 10 Generalidades o olaa tt 33 IA Cs ON MN UO Male arnold en ea 33 TOA ee ae el 33 nn E O ES 33 SQL Developer User Manual OA AS SLO A ne nn ee A NA 33 IOS DDC AAG CO usara da caciita ds 34 OS OO ANA F Oe bee ee ene ee eee A AN 34 TOS ZION ai ia 34 NOB 0 tic atin Morte eave tai an wate esi kCet ci nabs dG Raise A etelaenmen ceca 34 OAT FON erste a a cist era ee en nates 34 A ZA GE LICE CA A E TT A a 34 1043 ODIOS vse ts tas Soe ed lee etienne that te te de Ce a 34 A Re Rte tan ne awl Berne Rte 34 1O OI penta teenie O mn ree A tr ECE SRO Ee RT iS RET FP 35 IO ORIGINS 4 iene sek tcc see o lseameens 35 Ma SER OT Medal ss ees RS eee 36 12 EXIeNSIONS AE E tn ss Te ni 37 12 Standard extensions isa dla ros 37 12 11 Catalog Schema Compari SO asri Mao einen 37 121 2 Dissolve dependence ninia 38 12 2 Microsoft SQL Server exenta 39 A RS EN A
6. 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 tab as spaces option 10 4 4 Display General Display Appearance Editor Drivers Plugins Look and Feel System Look and Feel v _ Decorate title bars and borders of windows requires restart Preview File Edit Causarum enim Misc Table cognitio EE eventorum A Red v le Colors Sy Numbers V Check button One Two y epee E 4 _ A gt 1 000 TextField Radio button Settings General Display Appearance Editor Drivers Plugins Font Name E v Size 122 Caret Options Shape Vertical line v V Automatic indent Caret blinks O Insert tab as spaces Display E Character v E select folder name occurrences SELECT fld name AS folder name P COUNT FROM folders fld only accept system folders WHERE fld nam
7. 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 a Databases A GS HADUTFS NBG SOLYP DE system Oracle amp 4 Database Navigator PR ECOGAS E a Schemas schema ce y PUBLIC iy ANONYMOUS iy CHIMERA FA Tables Views Y Materialized views A Indexes p Procedures f Functions Packages E D INTMED_SYNCHRO_OPTIMIZE 20 x Routines p DATA_PRODUCER in rowid in out clob pl PUSG_DELETE in varchar2 in number in nurr p PUSG_INSERT_UPDATE in varchar2 in numb 29 Dependencies 3 PAGE_USAGES E STANDARD a ve Package Bodies Triggers A Sequences 39 Types 4 Type Bodies A Invalid Objects 3 8 Synonyms Libraries 5 Database Links a CTXSYS Users lg User Roles 8 User System Privileges 8 User Object Privileges Roles 28 Privileges Tablespaces 4 Rollback segments gF localhost sample2 pbpublic PointBase El Haddock master sa Microsoft SQL Server fe mymimer sysadm Mimer SQL Engine iambicTimeAndE
8. uses the SQL Server function sp monitor Members of the server role sysadmin have the permission to execute this function by default 12 2 4 Remote command shell This extension emulates a command shell synchronously The command control does not return until an executed command has finished Key input as wanted by some commands is being ignored The extension uses the SQL Server function xp cmdshell Members of the server role sysadmin have the permission to execute this function by default m Monitor Haddock master sa General Aug 8 2004 12 50 12 PM Aug 8 2004 12 50 00 PM 12s 30 1 Os Os 0 Os Os 0 CLLCLELELELTELELELELETETELELELEEETEELLEEEE 5712s 11s 91 Packets 63 47 86 7 0 0 Total 311 0 152 1 0 0 Refresh on the database server The shell works ca Remote command shell Haddock master sa C WINDOWS system32 gt dir sh dll ger in Laufwerk C ist Lokaler Datentrager C WINDOWS system32 gt 40 43 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 th
9. 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 processing 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 24143 SQL Developer User Manual Enable output echo Y Commit ta Rollback 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 Sends the COMMIT command to the database and confirms all pending changes Sends the ROLLBACK command to the database and discards all pending changes 25 43 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 is XSLPROCESSOR HADUTF8 NBG SOLYP DE scott FREATE OR REPLACE package SY5 xslprocessor authid current user as ptt Processor interface type F TYPE Processor 15 RECORD ID NUMBER NOT NULL 1 Stylesheet interface type ay TYPE Stylesheet 15 RECORD ID NUMBER NOT NULL 1 ft Returns a new processor instance f FUNCTION newProcessor RETURN Processor Free XSL Processor wg
10. AE R EE AEE EE E E EA EA EE EEEE 39 12 22 A de RG NOTE A AR A de 39 1222 MONO RAS SR a a da de me Oe ER de 40 12 2 4 Remote command Shell nissan ia 40 12 SMV SOL CXIGMSIONS Rue a in de 41 235 Processes a ae a ee RU ea te 41 A SO ON em en Re O 42 T24 EXI PAR A A ici 42 12 42 SESSION Sureste rd dll Colo dalla 42 AT ES OD a aCe ee eee Reet eter Carney toe ete ee eon ve PE Re aN Sean net nee renee ere 43 12 4 Oracle Toxico sto telecast aboot eo ON tend 43 3 43 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 43 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 Ri
11. BG SOLYP DE system Catalog Schema 34 CHIMERA For each side select an adapter and a catalog or ro Adapter a NEG DE sch ema pt HADUTFS NBG SOLYP DE system Catalog Schema 2 DRXMCMS Use the options panel to control the properties to opin com p are Ignore case in identifiers i Table options Common column options Press Start to begin with the comparison The result re aman ou A Include primary keys Include native type name will be displayed as a detailed text report A AR O Include row count Include NULL NOT NULL View options Include default value Include views O Include ordinal position C Include row count C Include remark B Catalog schema comparison CHIMERA DRXMCMS 43 Catalog schema comparison CHIMERA DRXMCMS Apr 2 2005 12 34 58 AM Tables Table DR SOTBIN CONTEXT I I has been added Table DR OTBIN_CONTEXT_I K has been added Table DR OTBIN_CONTEXT_I N has been added Table DR OTBIN_CONTEXT_I5R has been added E Primary key DR OTPUSG_CONTEXT_15K SYS_IOT_TOP_33425 has changed Name has changed SYS_IOT TOP 33425 SYS_1OT_TOP_35191 Primary key DR OTPUSG_CONTEXT_15N 5Y5_I0T_TOP_33430 has changed Name has changed SYS_10T_TOP_33430 SYS_10T_TOP_35196 column MCMS_BASIC_WORKFLOW LANG has been removed E Column MCMS_BASIC_WORKFLOW NOTIFIED has changed Java data type has changed VARCHAR DECIMAL Native type name has c
12. Bookmarks C Projekte jb SOLDeveloper testdata sfsrepos sqlddm E X Hy PIS Objects UT ORATXT_DUSG_SRC UN SFS_CATEGORIES EI SFS_CHILD_ACL E SFS_CHILD_ACL_DEF UT SFS_CHILDREN UT SFS_CHILDREN_DEF EI SFS_CLOB_TMP UN SFS_DOCUMENT_BINARIES SFS_DOCUMENT_USAGE_STATE F5 _DOCUMENT_USAGES UM SFS_DOCUMENT_VERSIONS UM 5F5 DOCUMENTS UM SFS_EXTERNAL_KEY Fa CEC CYTENRIAI VEY VAIIIC ul por ayh 2 Pre v DD a a m Oracle Oracle JDBC driver hs 20 2 0 2 0 NumPad FS Oracle9i Release 9 2 0 1 0 Production Server Release 9 2 0 1 0 Production HADUTFS NBG SOLYP DE system 7143 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 Opens the connection dialog Reopen connection Closes the currently selected connection and opens it again With this function you can reactivate aborted connections e g aborted by time out Close connection 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 of the active editor window to a file This function is available after an editor window has been titled with
13. Ctrl Z press Ctrl Y to redo text changes 20 43 SQL Developer User Manual 6 1 Statement Editor The Statement Editor is used to execute a single statement The content of the editor window is sent to the database at once SQL Editor 1 HADUTF8 NBG SOLYP DE scott Statement SQL SQL Script AE A EEIE select e ename e job P d dname from emp e left join dept d on d deptno e deptno 71 Modified inset E h anm ENAME JOB DNAME CLERK ACCOUNTING PRESIDENT ACCOUNTING MANAGER ACCOUNTING ANALYST RESEARCH CLERK RESEARCH ANALYST RESEARCH MANAGER RESEARCH CLERK RESEARCH CLERK SALES AA bd et fl D ms execution lo ms fetch il 4 rows 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 If the current BLOB is a picture you can view it by changing to the Image tab The supported formats are JPEG GIF and PNG F
14. DA 87 80 EB 81 7F FD v xu Close Close BLOB viewer with hexadecimal and image view 21 43 SQL Developer User Manual 6 1 2 CLOB Viewer 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 i GS Klire linkedInageReference xnmlns lire http siww solyp com schema editor linkedimagereference xnlns lir http siwww solyp com schema editor linkedimagereferencetype gt lt lir imageReference xmlns lir http siuvww solyp com schema editor linkedimagereferencetype binaryld 2648 gt lt lir imageMap xunlns lir http siuww solyp com schema editor linkedimagereferencetype gt lt im shape xulns im http siwm 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 xnlns sh http siwiwy solyp con schema editor shapetype pageld 2964 gt lt im shape gt lt im shape xmins im http siuuw solyp com schema editor imagemaptype type circle nane Loch coordinates 92 256 8 g
15. RA IDx_V LUES CHIMERA LANGS m CHIMERA LINK_TERMS m CHIMERA LINKS CHIMERA MCMS_BASIC_ WORKFLOW CHIMERA MCMS_PRIVS v Dissolve dependencies Identifiers DELETE Script Sort Dependent objects at start DELETE semantics Dependent objects at end INSERT semantics List CHIMERA LINK_TERMS CHIMERA LINKS CHIMERA ALLOWED_ELEMENT_TYPES CHIMERA LANGS CHIMERA GLOBAL ACCESS CONTROL CHIMERA ELEMENT TYPES CHIMERA ALLOWED SUB PAGES CHIMERA ACCESS CONTROL LIST Cancel 38 43 SQL Developer User Manual 12 2 Microsoft SQL Server extensions 12 2 1 Show Plan With the Show Plan extension you can analyze the EEE execution plan of a query Paste the statement to analyze from the clipboard into the SQL editor in the rem upper part of the dialog You can also load a p re um statement from a file using the Open function vm oe replied p plie where 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 31 Modified Insert Execution plan L SELECT cost 0 021052586 GP Nested Loops Inner Join cost 0 021050276 S A Bookmark Lookup cost 0 012707889 E Index Seek cost 0 0064324792 E Clustered Index Seek cost 0 0082458295 12 2 2 Processes This extension shows all processes running on the database for the currently selected adapter U
16. SQL Developer User Manual Version 2 1 0 Copyright Jan Borchers 2000 2005 All rights reserved SQL Developer User Manual Table Of Contents A th OT AC AE A acc E AT EAEAN EAE EEDA IE E E N E TEE 4 ZOGEN SLINE e 5 2 1 LICenSe Registration issues nanas antes AN 5 2 2 Configure Database Drivers sua en ie ce eus Cr Dineti e 5 2 9 EStaDIISNINO CONNGGUON Sii a a a E 6 3 DOSKUOD aa 7 SIM E A 8 Ce O o o oo 8 A A A a O roo o OE tn ace D a a oY ee 9 SESE A uo arado lia 10 SN Ce Ni lle et nn iii 10 SOE One LE NO crunch E EET en cen es ape ate a ee ATETA eae EN EE E EEE A on E ean ae 10 22 TOOB AU ate Rate O II AA 11 SS VID WVINGOW AT nent E R 11 SA OUT CNG VOW RS ne ie Cat a ii 11 A Database NaVId alo Sd casse ane lia 12 AFOD OCO del nine D ti n re le he 13 Ay COMINO idad RE G 14 42 1V ICA DO WS EL dat ou minier na tre re ee A tue 15 42 2 EXended Quick BrOWS Sun tii 15 5 Connection DialoOd vacias ei pata 16 D Ba SC CONNECCION menare r a a a codiciada 17 52 Oracle COME cean adidas 18 SBM DBZ COO CO ani td ed Ore a en Do ls 18 5 4 Microsoft SQL Server Connector oisi mu ia 18 5 5 Firebird ORME Ouest tev lea a a ill dd CE Cu 19 9 0 OUDECCONN CIOL aid ea ia 19 O SQL EGIUOl S a senactecaee 20 6 es FS 1 Sg CS 1g oa 111 Geen RS A a e e iba 21 OMI BELOB VICWE aoh a omer NT RON a oe 21 SUEZ CWOB VIEWS en ns cam ie titi eh a 22 6 1 3 COMMAaNGS EGION a ada tn 22 6 14 Commands Result SOU Es Re NS nn ee
17. a filename after an Open or Save as operation Save as 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 New diagram Opens a new Diagram Editor Open diagram Opens a diagram file EF Save diagram 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 E Save diagram as Writes the current diagram to a file with a new filename Prints the content of the active window Exit Exits the application All open connections are closed automatically 8 43 SQL Developer User Manual 3 1 2 Edit a SQL Statement Y SQL Script 5 Stored Program Editor AB AE AB AB 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 uncomments the select
18. by using the Create button Use the Execute button 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 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 Sessions HADUTF8 NBG SOLYP DE system terminate the selected sessions The 9 8 Fite kenrite v ike MEE Refresh button re reads all information E IR TSE NE of all sessions o oo ee Use the Filter field to select a filter Bsh Muf Sail DEDICATED ss a Jaooo criterion and specify a filter pattern in ACNE DEDICATED eye YSTEN 7 HADDOCK rl the like field The filter works case Ti ACTIVE DEDICATED sys JC Nu insensitive and supports the wildcard ACTWE DEDICATED sra SYSTEM INACTIVE DEDICATED SYSTEM Nt haddock 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 lt Another click on the same column frs header reverses the order 42 43 SQL Developer User Manual 12 4 3 Jobs The Jobs extension shows all jobs of the current user If your user account has appropriate permissions you ca
19. 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 analyze their dependencies for Press the Next button to start the analysis A 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 HADUTF8 NBG SOLYP DE system Catalog Schema 4 CHIMERA Objects CHIMERAACCESS_CONTROL_LIST m CHIMERA ALLOWED_ELEMENT_TYPES m CHIMERAALLOWED_SUB_PAGES oJ CHIMERA BINARY_DATA m CHIMERA BINSRY_TERMS E CHIMERA BINARY_USAGES A CHIMERA COMPATIBILITY E CHIMERA DAS OTPUSG_CONTEXT_1 1 E CHIMERA DA OTPUSG_CONTEXT_I K E CHIMERA DRSOTPUSG_CONTEXT_I N E CHIMERA DAS OTPUSG_CONTEXT_I A m CHIMERA ELEMENT_TYPES m CHIMERA GLOBAL_ACCESS CONTROL E CHIMERA IDX_DEFINITIONS CHIME
20. 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 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 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 Opens a dialog for the fast creation of joined queries on tables Creates a new database object as a child of the selected object type Modifies the selected database object Modifies the name of the selected database object Removes the selected database objects At this position SQL Developer provides access to database specific extensions where applicable Creates a DDL script for all selected database objects Copies the physical identifiers of the selected database objects to the clipboard Copies the identifiers of the selected database objects as shown in the database navigator to the clipboard Collapses the subtree of the selected database object on all levels Refreshes all children of the selected tree node 14 43 SQL Developer User Manual 4 2 1 Quick Browse This function is used for the quick creation of simple SQL
21. e LIKE systems OR fld id lt 1000 GROUP BY fld name 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 43 SQL Developer User Manual 10 5 Drivers The Drivers tab shows a tree with all registered ET driver libraries SQL Developer Can use for General Display Appearance Editor Drivers Plugins establishing connections to a database Each entry ERA on the first tree level shows a library name and its Een file path The child entries on the second level show ES Firebirdsql Full jar C install database Firebird IDBC FirebirdSQL 1 5 0Beta information about the driver classes provided by the amp jconn2 jar C ProgrammelSybaseiSharedij Connect 5_5 classes HE i s mysql connector java 3 1 0 alpha bin jar C Programme SQLDeveloper d irs mkjdbc jar C install database Mckoi mekoil 0 2 5 postgresql 8 0 310 jdbc3 jar C Projekte jb SQLDeveloper HEAD workspa ES mimjdbc3 jar C install database MimerSQL JDBC mimjdbc 3_15 amp sapdbc jar C Programme sdb programs runtime jar idbc jar C Programme CA Ingres IT ingres lib vo BE BE Ee E 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 usin
22. e 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 E Processes MySQL root localhost RAM ESS Process ID User Host Database 1127 0 0 1 3015 mysql Command Sleep Time 4666 State Info 127 0 0 1 3020 mysql Sleep 57 127 0 0 1 3021 mysql Query 0 1127 0 0 1 3024 mems Sleep 14 SHOW FULL PROCESSLIST Processes 41 43 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 Explain Plan HADUTF8 system the clipboard into the SQL Plan Table SYSTEM PLAN_TABLE C Statement ID Cd editor in the upper part of Jes the dialog You Can also aoe ae on d deptno e deptno load a statement from a file using the Open function B1 rn Execution plan You can specify an optional a Cost Owner Name Type ae Rows ID for the statement to A nn 5 on o execute In this case the AE TABLE ACCESS FULL 2 SCOTT 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 you need a plan table Please ensure that a plan table exists before the first attempt to build a plan If no such plan table exists you can create one
23. ected 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 within 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 43 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 10 3 2 Preview
24. ed 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 43 SQL Developer User Manual 3 1 3 Extras Database info Catalog Schema Comparison Dissolve dependencies lt Extensions gt Settings 3 1 4 Window Cascade Tile vertical Tile horizontal Close all lt Windows gt 3 1 5 Help di E gt Tip of the day License SQL Developer Homepage About SQL Developer 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 access to all vendor specific extensions Opens t
25. er castor Password tratt Name ODBC in C WINDOWS ODBC INI 3 The fields User and Password define the authentication parameters 19 43 SQL Developer User 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 If 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
26. er 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 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 3 IBM DB2 Connector Use the fields Database Host name or IP address and Port to address the server you want to create a connection with CA Database pollux The connector for IBM DB2 databases uses two different ms sors T Por 50070 driver types to create connections The network driver ts iam 082 Network Drive g and the application driver Press the Info button in the 7 connection dialog to test if the required is available fee The fields User and Password define the authentication parameters 5 4 Microsoft SQL Server Connector The Microsoft SQL Server connector uses the JDBC ODBC Bridge driver To establish connections you need the Microsoft SQL Server ODBC se driver to be installed on your computer Server localhost __ Port 1438 7 Database master With the fields Server name or IP address Port default port is 1433 and Database
27. 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 des Settings dialog After you have specified the parameters for the selected connector you can create a new connection by pressing the OK button 16 43 SQL Developer User Manual 5 1 Basic Connector The Basic connector is a universal connector creating connections with any JDBC driver All other connectors are specialized connectors for certain databases Note If a specialized connector exists for your a gt database you should prefer that connector because its Dive Commsai be Diver configuration will be much easier URL iebempsak focalhost230S polt User root To create a connection with the Basic connector you ft have to specify at least a driver and a URL You can 7 _ A get both parameters from the driver documentation of x fae Value the vendor Both fields are editable dropdown lists 3 sadom E providing preconfigured values you can use for various popular databases 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 optional and enables you to enter a profile name manually If the field is left empty SQL Developer automatically gene
28. g the Up and Down buttons If 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 gt 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 QR m od u e S fro m th e p ug n S fol d e r i n th e S Q L General Display Appearance Editor Drivers Plugins Developer installation directory Last modified 535 KB Jul 24 2005 12 50 17 PM 91 KB Jul 24 2005 12 50 20 PM iE ibmcloudscapeprovider jar 16 KB Jul 24 2005 12 50 21 PM E ibmdb2provider jar 77 KB Jul 24 2005 12 50 24 PM ibminformixprovider jar 8259 Bytes Jul 24 2005 12 50 24 PM ingresprovider jar 45 KB Jul 24 2005 12 50 27 PM iE mckoiprovider jar 38 KB Jul 24 2005 12 50 29 PM iE mimersqlprovider jar 70 KB Jul 24 2005 12 50 37 PM iE msaccessprovider jar 67 KB Jul 24 2005 12 50 31 PM msdbaseprovider jar 32 KB Jul 24 2005 12 50 32 PM msexcelprovider jar 44 KB Jul 24 2005 12 50 35 PM mssqlserverprovider jar 278 KB Jul 24 2005 12 50 43 PM mstextprovider jar 27 KB Jul 24 2005 12 50 44 PM mysalprovider jar 102 KB Jul 24 2005 12 50 48 PM odbcprovider jar 31 KB Jul 24 2005 12 50 49 PM oracleprovider ja
29. ght after having started SQL Developer the first time you ME should register your license in the license dialog Only with a Welcome to SQL Developer registered license you can use all functions of SQL Developer er T yau dert have a cense yet please vet he SQL Developer homepage to get an evaluation license r or to purchase 4 permanent license First save your SQL Developer license to your computer To eee avoid unauthorized access to your license you should copy the To instal anew icense copy your icense key Into the license to your personal user directory le 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 Configure 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 Es Click on the Dri j ver S tab General Display Appearance Editor Drivers Plugins eee Fojdbc1 4 jar C linstallidatabase Drivers Oracle 10g 1 0 2 0 ef oracle jdbc driver OracleDriver This tab shows all drivers curren
30. hanged VARCHAR2 NUMBER Size has changed 1 1 0 Default value has changed N A column MCMS_BASIC_WORKFLOW PAG_ID has been removed Column MCMS BASIC WORKFLOW PN ID has been added Column MCMS_ BASIC WORKFLOW PUSG_NR has been added E Primary key MCMS_BASIC_WORKFLOW MBW_PK has changed Colums have changed Table MCMS_ROLES_KEY_ATTRIBUTES has been added Table MCMS_ROLES_KEY VALUES has been added Table ORATXT_BIN_5RC has been added Column PERSON_ATTRIBUTES VALUE_TYPE has been added Primary key PERSON_ATTRIBUTES PA PK has changed Colums have changed Table PERSON_MULTI_ATTRIBUTES has been added Table PERSON_MULTI_VALUES has been added Column PERSON VALUES BLOB VALUE has been added Column PERSON VALUES CLOB VALUE has been added Column PERSON VALUES VALUE TYPE has been added Foreign key PERSON_VALUES PV_PA FK has been added amp Foreign key PERSON VALUES PY PKA FEK has been removed A Table PLAN TABLE has been removed A Table PLAN TABLEZ has been removed EJ Column TERMS POSITION has changed Default value has changed NULL Table USER_GROUP_KEY ATTRIBUTES has been added Table USER_GROUP_KEY VALUES has been added Viens G View VIEWL has been removed 30 differences have been found 37143 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
31. he 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 Opens a web browser and navigates to the SQL Developer homepage Shows general information about SQL Developer 10 43 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 Soa nl 8 HADUTFS NBG SOLYP DE system iF CD ae HR MAMIE D 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 modal windows are displayed in the MDI Multiple Document Interface window area The window area itself i
32. ined 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 43 SQL Developer User Manual 5 Connection Dialog The connection dialog is accessible through the File ESSOR menu and the Open connection command Profie P v new JC Delete _ For each PIENS connection SQL Developer creates a Oracle PointBase PostgreSQL SQLBase SQL Server Sybase 454 Text profile that is displayed in the dropdown list in the aa DB2 dBASE Excel Firebird Ingres Mckoi Mimer SQL MySQL ODBC upper part of the dialog When the user selects a stored profile the connector described by the profile us gets selected and its fields are preset ee 7 Name To create a new connection select a suitable 507e 2777 sporedsroumens connector first All available connectors are displayed ai as tabs Except for the Basic connector the required drivers for a connector are predefined Press the nfo button to show the information about the driver name driver class vendor URL and status If a required driver
33. lt 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 ANS192 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 pe Procedure term procedure Search string escape 7 Max catalog name length chars 0 Max char literal length chars 2000 Max cursor name length chars 0 Max index length bytes lo Max procedure name length chars 30 Max row size bytes it l d committed oO Q 00 a E a E a 20 32 43 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 or executing queries Whenever a value is set to zero the defaults of the driver are used for the respective parameter Note The settings of the time limit parameters are supported by a few drivers only 10 1 2 Misc Use the option execution of sel
34. mark 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 displayed 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 i New bookmark Creates a new bookmark underneath the selected folder 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 H Copy Copies the selected node bookmark or folder to the clipboard i Paste Pastes a bookmark or a folder from the clipboard lt 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 27143 SQL Developer User Manual Split view vertically
35. n also show all A Jobs of the database instance Press the Run button to run the selected job directly Use the Activate and Deactivate buttons to start and stop a selected job With the Extract DDL button you can generate a creation 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 Jobs HADUTF8 NBG SOLYP DE system K EBx amp Show DBA jobs Filter No filter like Us e Last Date 2003 08 28 08 28 46 0 Job User This Date Next Date 4000 01 01 00 00 00 0 Total Time s i Broken true 2003 08 28 08 28 47 0 4000 01 01 00 00 00 0 true 2003 08 28 08 28 46 0 4000 01 D1 00 00 00 0 2003 08 28 08 28 47 0 4000 01 01 00 00 00 0 true 2004 08 06 21 13 20 0 2004 08 06 21 14 20 0 9 6 4 true 7 1 false values of a column by clicking the column s header with the mouse Another click on the same column header reverses the order 12 4 4 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 user a
36. nd are using Oracle Text The child nodes of each schema node show detailed information about indexes sections stop word lists and preferences For indexes there are additional functions available for synchronization optimization and recreation The Refresh button re reads all Information in the tree Oracle Text HADUTF8 NBG SOLYP DE system Ex XHA Index 2 4 CHIMERA Indexes a 3 Section Groups S k OTPUSG_SECTION_GROUP conf MAINHEADING ifan NAME oof SUBHEADING x Stoplists x OTPUSG_STOPLIST E Preferences OTPUSG_DATASTORE OTPUSG_FILTER OTPUSG_LEXER CTXSYS DEMOMCMS1 KGAL MCMSSQLI SANT SPD Be e E H ee WKSYS Schema Name Table schema Table name Table key Text column name Indexed documents Pending documents Status Last error Error text CHIMERA OTPUSG_CONTEXT_ CHIMERA ORATXT_PUSG_SRC TYPE PN_ID PUSG_NR MAX VC 0 0 INDEXED Synchronize Optimize fast Optimize full Rebuild 43 43
37. o 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 Select all Selects all objects in the diagram Invert selection Se x E Inverts the selection state of all objects Grid on off Toggles the grid display Snap to grid Preferred size Automatic layout To front To back Foreground color Line color Background color Zoom in Zoom out Toggles the snap to grid behavior Changes the size of all selected objects to their preferred size Automatically applies a layout to all diagram objects Moves all selected objects into the foreground Moves all selected objects into the background Changes the foreground color of all selected objects Changes the line color of all selected objects Changes the background color of all selected objects Increases the zoom factor of the view Decreases the zoom factor of the view Sets the zoom factor to the specified percentage value Allowed values range from 1 to 1000 30 43 SQL Developer User Manual 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 8 2 1 Import objects Thi
38. or BLOBs with different format no picture is shown H Data Image Data Image 0000 0000 47 49 46 38 39 61 C8 00 B4 00 F7 00 00 00 00 00 GIFS9a ne T Ai po P 0000 0010 80 00 00 00 80 00 60 80 00 00 00 80 80 00 80 00 x 0000 0020 80 80 CO CO CO CO DC CO A6 CA FO 4A 40 92 7A ZF JB z 0000 0030 2C 7F 3F 3E 77 58 40 84 78 39 64 5B 6E 88 6F 60 gt wX x9d n o 0000 0040 24 1C 92 2E 2B 96 35 35 90 4A 40 92 57 54 90 6B 55 J WT k 0000 0050 SF 8D 7C 74 8D 9B 37 34 9B 46 45 BS 37 34 B3 47 _ t 74 FE 74 6 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 OF 89 84 B9 e yg r us 0000 0080 83 85 00 FF 00 94 94 94 9C 94 7B 9C 94 8C SC 94 fas 0000 0090 94 9C 9C 84 9C 9C 8C AS 94 84 AD SC ZE AS 9C 52 0000 0040 AS 9C 67 A5 9C 73 AS 9C 7B AS 9C 8C AD 94 94 BS g s 0000 0050 9F 3E BD AB 3B BS A4 44 Bl 9C 52 AE 9F SD B9 A gt J R 7 0000 00C0 54 BD AD 54 AD 9F 6D B5 AS 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 JE 1A B3 2F 0000 00E0 2E B5 1C 16 D2 2F 27 CB 40 36 BB 52 4E AD 4D 4A 6 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 E8 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 63 BA 83 81 CC 65 65 ES 6A 69 o ee ji 0000 0120 F 7B 76 E9 78 75 FC 88 85
39. 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 a a C ME ACCESS_CONTROL_LIST ACL_UGR_FK 4 C sLoBAL_ACCESS CONTROL GCL_UGR_FK 3 Y 3 UGR_USERS UU_UGR_FK E CREATION_DATE a C A USER_GROUPS UU_UGR_FK GB SPECIAL_GROUP_TYPE ce V I WELL_KNOWN_PERSONS UU_WKP_FK s Y E USER_GROUP_GROUPS UGG_MUG_FK a C 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 node referencing the primary key of the child node parent child n 1 A red key indicates that a foreign key is def
40. r 784 KB Jul 24 2005 12 51 04 PM pervasiveprovider jar 10 KB Jul 24 2005 12 51 05 PM pointbaseprovider jar 57 KB Jul 24 2005 12 51 07 PM iE postgresqlprovider jar 61 KB Jul 24 2005 12 51 09 PM sqlbaseprovider jar 31 KB Jul 24 2005 12 51 10 PM sybaseasaprovider jar 88 KB Jul 24 2005 12 51 12 PM gt 35 43 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 EE Tip of the 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 43 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 sas view structure of two catalogs or schemas The f a comparison always compares a eft and a right side Adapter Ud HADUTF8 N
41. rates 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 Fm name In the fi rst column To remove a name value pair Select the arguments you want to specify as connection parameters just delete the name in the first column of the desired HEE oes Ses entry Te A TEE pollux Database name Some drivers provide information about their supported issa he Posodi use or at vallowLoadLocallntile true Should the driver allow u J arguments Press the Supported arguments button to mata a show them in the Arguments dialog and to copy selected arguments to the table 17 43 SQL Developer User Manual 5 2 Oracle Connector The Oracle connector supports connecting the server by specifying Host name or IP address Port and S D or a Net Service definition from a TNS Names file To use Net Service definitions you must specify a TNS z Names file providing the definitions Usually the file iS tosrotsio ocahos EE installed together with an Oracle server or Oracle client Onesevice in a subfolder of the Oracle Home directory in the path lt Oracle Home gt network admin User scott Password 4444 Connect as Default v In any case you must specify the user name of the Oracle schema and the password With the field orme 3 Connect as you can choose if the us
42. referred width of the cells in the table body 23 43 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 database 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 gaoa y ss update emp entries for department 101 Il update emp et deptno 102 where deptno 101 insert emp entry 6 2 1 Commands Skip to start Skip back Execute Single step Skip next Skip to end Enable semicolon terminator P Enable slash terminator 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
43. res f Functions Packages Q Package Bodies 8 Triggers H E Sequences AP Types 4 Type Bodies AN Invalid Objects fae Synonyms Libraries 3 Database Links ES 4 SH Au S PK_EMP pr E EMPNO ce FK_DEPTNC 21 Exported Key ll EMP TABLE 2 PK_EMP IN 3 Total size a Materialized views EMP HADUTF8 NBG SOLYP DE system SQL Statement SOL Script XA MD SELECT el EMPNO el ENAME el JOB el MGR el HIREDATE el SAL el COMM el DEPTNO dl DEPTNO dl DNAME dl LOC FROM SCOTT EMP el INNER JOIN SCOTT DEPT dl ON d1 DEPTNO En Rd ESS EMPNO ENAME JOB 1 7369 SMITH 2 _ 499 ALLEN MGR H 7902 Deq 7698 Feb zo Open connection a Reopen connection D Close connection CLERK SALESMAN 7521 WARD SALESMAN 7566 JONES MANAGER 7654 MARTIN 7698 BLAKE 7698 Feb 7839 4pr 7698 Sep 7839 Ma PY SQL Statement L SQL Script Y Stored Program Editor gt Quick browse 7839 Juni 7566 Apr SALESMAN MANAGER Ctrl M 7782 CLARK cien TEE MANAGER ANALYST tion O ms fetch F3 22 Extended quick browse F4 New E Eii fir Rename X Remove ae Compile Enable Q Disable EE Import table ry Copy text st Collapse subtree Refresh node HADUTFS NBG SOLYP DE system Oracle SCOTT EMP Be iy Copy identifier Ctrl C
44. s function imports tables and views including their bidirectional references into the current diagram Catalog Schema Import Adapter HADUTF8 NBG SOLYP DE system If there is no open database connection yet at first the catsosiscnems y scor connection dialog will be displayed where you can select a connection profile or create a new one E Bonus Next the dialog for importing objects is shown Select a Sr as 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 31 43 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 Types Keywords Support Property Value Supports transactions Supports multiple transactions Supports read committed transactions Supports read uncommitted transactions Supports repeatable read transactions Supports serializable transactions Defau
45. s 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 If 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 H Database Microsoft SQL Server A Version 03 00 0760 Driver UDBC ODBC Bridge SOLSRV32 DLL Version 2 0001 03 35 1117 25 07 2005 12 15 53 Microsoft ODBC SQL Server Driver S5QL ati pene id Objectname NorthwindBackup dbo CustomerDemographics SQL State 50002 Base table not found Er 208 CustomerTypeID CustomerDesc lt AD 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 43 SQL Developer User Manual 4 Database Navigator The database navigator shows all connected databases in a tree view and provides access to single database objects
46. se the Details button to show the last executed SQL command for the selected process With the Kill process button you can pren terminate the selected processes The 2 rie nome vie IA Refresh button re reads all information Thread ID See Blocking em Database Ess CPU Physical 1 0 of all processes i N o no 21742 dbo no 0 master dbo no 3465 no 0 Imaster no 5716340 master no 5710031 no 0 master no 0 master no master no master no master no master no master no 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 es Le Ow oo oo oo oo oo oo O no no master SHS HN DM COO oO oO oO oO oO oO o oo oo OH ON ES MMMM MMM OPM mM Oo oOo Own oo oc oc oc 0000 0000 oO oo 0 oo oo oo o o oO BJ 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 master 39 43 SQL Developer User Manual 12 2 3 Monitor The Monitor extension provides a graphical user interface for the internal SQL Server monitor function Press the Refresh button to update the Statistics The extension
47. 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 diagram objects graphically Select one or more objects from the view to perform a function on them The selection is always synchronized with the 29 43 SQL Developer User Manual selection of the object list A 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 Right click on the line where the new vertex should be added An existing vertex can als
48. t lt im shape och coordinates 114 292 8 gt lt im shape xnlns im http siww solyp com schema editor imagemaptype CLOB viewer with XML syntax highlighting 6 1 3 Commands Editor x Execute Executes the statement Commit Sends a COMMIT command to the database and confirms all pending changes ta Rollback sends a ROLLBACK command to the database and discards all pending changes A1 Fetch all 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 COUNT Retrieves the number of rows the current statement would affect a Export data Exports the data returned by a SELECT statements to the clipboard or to a file 22 43 SQL Developer User Manual 6 1 4 Commands Result Set a Copy Copy column names Copy WHERE clause Adjust column width based on header Adjust column width based on header data Adjust column width based on data Copies the selected cells of the table to the clipboard Copies the names of the selected table columns to the clipboard Creates a WHERE clause from the selected cells of the table and copies it to the clipboard Adjusts all table columns to match the preferred width of the cells in the table header Adjusts all table columns to match the preferred width of the cells in the table header and body Adjusts all table columns to match the p
49. tly available With Loa oracle Jdbc OracieDriver the Add button you can open the file selection gt PESEE A ee dialog for driver files Select the previously downloaded driver and confirm with OK firs firebirdsql full jar C install database Firebird IDBC FirebirdSQL 1 5 0Bete iconn2 jar C Programme Sybase Shared jConnect 5_5 classes frs mysql connector java 3 1 0 alpha bin jar C Programme SQLDeveloper d hrs mkjdbc jar C install database Mckoi mekoil 0 2 2 postaresal 8 0 310 jdbc3 jar C Projekte jb SQLDeveloper HEAD workspa EH EE frs mimjdbc3 jar C install database MimerSQL JDBC imimidbc 3 15 sapdbc jar C Programme sdb programsiruntime jar iidbc jar C Programme CA Ingres II ingres lib Now the driver is shown in the tree and can be used gt 9 43 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 way Es to establish a database connection At least you need to specify a driver class name and a URL Details on both parameters can be found in the vendor s sete access ose ace enel Fiebed Ingres Mail Miner SOL YSOL obec driver manual o ME K URL J All other tabs contain specialized connectors for ue various databases Use the Info button to check if the
50. xpense mdb ACCESS E LI localhost gotcha postgres PostgreSQL v lt il gt W E H EE ee EE H E EEE IN HADUTF8 NBG SOLYP DE system Oracle CHIMERA ORATXT_PUSG_IND 12 43 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 Table column with foreign key Table column with primary and foreign key Index Index column eus SEE EC Function T Procedure synonym r Constraint Primary key constraint Foreign key constraint Unique key constraint Check constraint Trigger Sequence Generator Library Tablespace Package Module Type Role ES SF 4 E 6 L SHE Invalid object oot on on Privilege ag Dependencies 13 43 SQL Developer User Manual 4 2 Commands 2 Open connection Pa Reopen connection Close connection PP SQL Statement a SQL Script 29 Stored Program Editor 3 Quick browse 22 Extended quick browse New Edit Rename X Hi el B Remove lt Extensions gt qe Extract DDL Copy identifier uu Copy text a Collapse subtree Refresh node Opens the connection
Download Pdf Manuals
Related Search