Snippet Name: Add PSOUG Search to SQL Developer
Description: 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 looking at the AskTom or Oracle documentation sites can be checked.
Also see: » Make alternating color table rows auto...
» Convert Seconds to Hours:Minutes:Secon...
» Convert UK Dates To mySQL Format Dates
» Convert miles to feet, feet to miles, ...
» Highlight table rows on rollover
» Converting Rows to Columns
» Output mySQL data in columns
» Dynamically Add/Remove rows in HTML ta...
» TABLE: Multiple Columns
» Database Links: CURRENT_USER
» Instant Test Database with DCBA
» SELECT name columns
» CONVERT
» UPDATE: Update multiple rows
» INSERT: Multiple Column Table Or View ...
» INSERT: Multiple Column Table Or View ...
» Convert text to soundex
» Count rows in all tables
» List tables with more than 'X' rows
» Convert between Decimal, Binary, Octal...
» Convert LONGs to LOBs
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: April 04th, 2010
|
/*
A handy tip from the author of the Arkytekture blog at
http://psoug.org/blogs/arkytekture/
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 looking at the AskTom or Oracle
documentation sites can be checked.
While some of those 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>
*/ |