Home Code Snippets Oracle Reference Oracle Functions Oracle Error Codes Forum Oracle Jobs Oracle Blogs

Search PSOUG from SQL Developer !

Extend Oracle's SQL Developer to search PSOUG web pages and  see how much more productive you can be!

Anyone who's used SQL Developer may have noticed the search engines tucked away in the upper right corner of the screen.  With a nod to Firefox, the people who created SQL Developer made it easy to look up an error message on Google, consider going to Oracle Technology Network (OTN) forums with your SQL Developer issue, or checking the AskTom or Oracle documentation sites.  

While the sites provide valuable information, often they get into esoteric areas or long blogs.  PSOUG succinctly exposes the concepts that a developer needs right away with examples of usage and scripts that illuminate topics such as CREATE MATERIALIZED VIEW.

It's exceedingly easy to try out.  Add PSOUG to your search domains by placing an image file and a source file in the sqldeveloper/sqldeveloper/searchengines path of your installation.

First file: psoug.src

<search
   name="PSOUG"
   description="PSOUG Search"
   method="POST"
   action="http://psoug.org/search.htm"
   searchForm="http://psoug.org/search.htm"
   queryEncoding="utf-8"
   queryCharset="utf-8"
>

<input name="qwords" user>
<input name="querytype" value="allwords">
<input name="catid" value="0">
<input name="searchtype" value="basic">
<input name="submit" value="GO">

<interpret
    browserResultType="result"
    charset = "UTF-8"
    resultListStart="<!–a–>"
    resultListEnd="<!–z–>"
    resultItemStart="<!–m–>"
    resultItemEnd="<!–n–>"
>
</search>

Second file: psoug.gif

I downloaded the PSOUG title.gif and scaled it down by a factor of about 4.  Use whatever tool makes sense to manipulate your image such as GIMP (multi-platform)  or Microsoft's Image editor, or whatever works on the Mac OS/X into an icon-sized image.  Jpeg, png, gif are all acceptable formats.

Your files will be discovered automatically the next time you start SQL Developer.

This entry was posted in Architecture, Uncategorized. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

Post a Comment

You must be logged in to post a comment.