|
SQL Dev SDK:How To add a new sub folder to the database navigator
|
Apr 23 2009, 5:20 PM EDT |
|
edit |
|
Change:
There were only format changes (bold, italics, etc.) in this version. See this version for details.
(Word count: 760)
View all updates.
|
|
SQL Dev SDK:How To add a new sub folder to the database navigator
|
Apr 23 2009, 5:19 PM EDT |
|
edit |
74 words added
|
Change:
The following user defined extension defines an action for the forth level node.<?xml version="1.0" encoding="UTF-8"?><items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:noNamespaceSchemaLocation="dialogs.xsd"> <item type="Level4" reload="true" removeFromParent="true"> <title>Rename Level4</title> <iconName>oracle.ide.resource.IdeArb:RENAME_ICON</iconName> <prompt> <label>New Table Name</label> <default><![CDATA[SELECT 'DefaultName' FROM DUAL]]></default> </prompt> <prompt type="confirm"> <label><![CDATA[Are you sure you want to rename this Level4?]]></label> </prompt> <sql> <![CDATA[ALTER
View changes from previous version.
(Word count: 760)
View all updates.
|
|
SQL Dev SDK:How To create a muliselect nodes action
|
Aug 6 2008, 11:23 AM EDT |
|
edit |
1 word added
1 word deleted
|
Change:
own SQL Developer extensions. Please add to this wiki any notes you would like to share regarding SQL Developer extension framework. ResourcesFile to build this sample extension ftp://ftp.oracle.com/svrtech/outgoing/sqldev_sdk/java_simple_tablespace.zipftp://ftp.oracle.com/svrtech/outgoing/sqldev_sdk/java_multi_select_nav.zipSimilar, Oracle By Example paper for SQL Developer 1.2.1http://www.oracle.com/technology/obe/sqldev_obe/extension/extensions.htmExtending SQL Developer 1.2.1http://www.oracle.com/technology/oramag/oracle/07-jul/o47sql.html
View changes from previous version.
(Word count: 808)
View all updates.
|
|
SQL Dev SDK:How To create a muliselect nodes action
|
Aug 6 2008, 11:22 AM EDT |
|
edit |
302 words added
|
Change:
public static final IdeAction DROP_SCRIPT_ACTION = IdeAction.get(DROP_SCRIPT_ID, "Build Drop Script", 1); private void init() { if (_menu == null) { _menu = new JMenu("My Custom Actions"); _menu.add(DROP_SCRIPT_ACTION); DROP_SCRIPT_ACTION.addController(this); } } public void menuWillShow(ContextMenu contextMenu) { init(); DBObject dbo = null; boolean add = true; Element[] els = contextMenu.getContext().getSelection(); if
View changes from previous version.
(Word count: 808)
View all updates.
|
|
SQL Dev SDK:How To create a muliselect nodes action
|
Aug 6 2008, 11:21 AM EDT |
|
edit |
1 word added
105 words deleted
|
Change:
The Addin specified in the above extension.xml will be called during SQL Developers startup. Its job is to initialize and setup the extension.For this simple example it just registers the XML files which provide the extensions functionality./*** @(#)TablespaceDiscoverer.java * Copyright 2008 by Oracle Corporation, * 500
View changes from previous version.
(Word count: 479)
View all updates.
|
|
SQL Dev SDK:How To create a muliselect nodes action
|
Aug 6 2008, 11:21 AM EDT |
|
edit |
2 words added
1 word deleted
|
Change:
<listener-class>oracle.dbtools.multiselect_nav.action.MultiSelectContextMenuListener</listener-class><listener-class>oracle.dbtools.multiselect_nav.action.MultiSelectContextMenuListener</listener-class></site></context-menu-listeners></jdeveloper-hook><feature-hook><description>Demonstrates a multiselect action</description><optional>false</optional></feature-hook></hooks></extension>Addin InterfaceThe Addin specified in the above extension.xml will be called during SQL Developers startup. Its job is to initialize and setup the extension.For this simple example it
View changes from previous version.
(Word count: 616)
View all updates.
|
|
SQL Dev SDK:How To create a muliselect nodes action
|
Aug 6 2008, 11:21 AM EDT |
|
edit |
478 words added
|
Change:
Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. Using Oracle SQL Developer, users can browse database objects,
View changes from previous version.
(Word count: 616)
View all updates.
|
|
SQL Dev SDK How Tos
|
Aug 6 2008, 10:51 AM EDT |
|
edit |
|
Change:
There were only format changes (bold, italics, etc.) in this version. See this version for details.
(Word count: 295)
View all updates.
|
|
SQL Dev SDK:How To create a custom editor for a Node
|
Aug 5 2008, 1:02 PM EDT |
|
edit |
533 words added
|
Change:
Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. Using Oracle SQL Developer, users can browse database objects,
View changes from previous version.
(Word count: 626)
View all updates.
|
|
SQL Dev SDK How Tos
|
Aug 5 2008, 9:18 AM EDT |
|
edit |
|
Change:
There were only format changes (bold, italics, etc.) in this version. See this version for details.
(Word count: 295)
View all updates.
|
|
How To use XML extensions within your Java extension
|
Aug 5 2008, 9:15 AM EDT |
|
edit |
22 words added
|
Change:
The How To Create a Java Defined Extension is a good example of how to integrate your XML into a java extension
View changes from previous version.
(Word count: 22)
View all updates.
|
|
SQL Dev SDK How Tos
|
Aug 5 2008, 8:01 AM EDT |
|
edit |
10 words added
10 words deleted
|
Change:
for a NodeEditorNavigator ExtensionsHow To create a custom editor formuliselect anodes NodeactionAction ExtensionsHow To create a toolbar button for an Editor How To create an action (rc context) for an EditorSQL Worksheet ExtensionsHow To extend the SQL WorksheetHow
View changes from previous version.
(Word count: 295)
View all updates.
|
|
SQL Dev SDK How Tos
|
Aug 5 2008, 7:56 AM EDT |
|
edit |
7 words deleted
|
Change:
How To create a multiple tab editor Action ExtensionsHow To create an action (rc context) for a Navigator NodeReport ExtensionsHow to create a fancy database reportJava Defined ExtensionsXML Extensions and JavaHow To use XML extensions within your Java extensionNavigator ExtensionsHow To
View changes from previous version.
(Word count: 295)
View all updates.
|
|
SQL Dev SDK:How To create an editor for a Node
|
Aug 5 2008, 7:55 AM EDT |
|
edit |
26 words added
|
Change:
The following example demonstrates how to add a editor tab (s) for a node.In this case we add 2 new tabs when displaying Table details.Example<?xml version="1.0" encoding="UTF-8"?><displays><display type="editor" style="null" enable="true" class="Oracle#TABLE" objectType="TABLE"> <name><![CDATA[My Tablespace Information]]></name> <query> <sql> <![CDATA[SELECT TABLESPACE_NAME FROM USER_TABLES WHERE UPPER(TABLE_NAME) =UPPER(:NAME)]]> </sql>
View changes from previous version.
(Word count: 109)
View all updates.
|
|
SQL Dev SDK:How To create an editor for a Node
|
Aug 5 2008, 7:44 AM EDT |
|
edit |
|
Change:
There were only format changes (bold, italics, etc.) in this version. See this version for details.
(Word count: 83)
View all updates.
|
|
SQL Dev SDK:How To create an editor for a Node
|
Aug 5 2008, 7:43 AM EDT |
|
edit |
|
Change:
There were only format changes (bold, italics, etc.) in this version. See this version for details.
(Word count: 83)
View all updates.
|
|
SQL Dev SDK:How To create an editor for a Node
|
Aug 5 2008, 7:43 AM EDT |
|
edit |
58 words added
|
Change:
class="Oracle#TABLE" objectType="TABLE"> <name><![CDATA[My Tablespace Information]]></name> <query> <sql> <![CDATA[SELECT TABLESPACE_NAME FROM USER_TABLES WHERE UPPER(TABLE_NAME) =UPPER(:NAME)]]> </sql> </query> <CustomValues> <TYPE>vertical</TYPE> </CustomValues> </display> <display type="editor" class="Oracle#TABLE" objectType="TABLE" style="Code" enable="true" display="Code"> <name><![CDATA[Drop Table]]></name> <queries> <query> <sql> <![CDATA[SELECT 'DROP TABLE ' || :NAME || ' CASCADE;' FROM DUAL]]> </sql> </query> </queries> </display></displays>
View changes from previous version.
(Word count: 83)
View all updates.
|
|
SQL Dev SDK:How To add a new sub folder to the database navigator
|
Aug 5 2008, 6:50 AM EDT |
|
edit |
|
Change:
There were only format changes (bold, italics, etc.) in this version. See this version for details.
(Word count: 643)
View all updates.
|
|
SQL Dev SDK:How To create an action (rc context) for a Navigator Node
|
Aug 5 2008, 6:28 AM EDT |
|
edit |
2 words added
2 words deleted
|
Change:
TablespaceTable Name. There is also a confirmation text.SQL "ALTER TABLE" is used to change the name of the tablespace.table.Example<?xml version="1.0" encoding="UTF-8"?><items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="dialogs.xsd"><item type="TABLE" reload="true" removeFromParent="true"><title>Rename Table</title><iconName>oracle.ide.resource.IdeArb:RENAME_ICON</iconName> <prompt><label>New Table Name</label></prompt> <prompt type="confirm"><label><![CDATA[Are you sure you
View changes from previous version.
(Word count: 252)
View all updates.
|
|
SQL Dev SDK:How To create an action (rc context) for a Navigator Node
|
Aug 5 2008, 6:18 AM EDT |
|
edit |
169 words added
13 words deleted
|
Change:
list. Click in the Location field, and click Browse to add the location of the table_action.xml file. Restart Oracle SQL Developer to register this new extension. You should now see that there is an action available (Rename Table), when you right click on a table node in the databases navigator.
View changes from previous version.
(Word count: 252)
View all updates.
|