Re: recent drivel posted by Tony Rogerson on his blog

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 02 Oct 2007 16:35:45 -0700
Message-ID: <1191368132.302991@bubbleator.drizzle.com>

Shakespeare wrote:

> "DA Morgan" <damorgan_at_psoug.org> schreef in bericht 
> news:1191356171.450453_at_bubbleator.drizzle.com...

>> Shakespeare wrote:

>>> "DA Morgan" <damorgan_at_psoug.org> schreef in bericht 
>>> news:1191339240.206371_at_bubbleator.drizzle.com...
>>>> Richard Foote wrote:
>>>>
>>>>> Perhaps Oracle has colour coded syntax after all :)
>>>> 11g does ... for example:
>>>> exec dbms_workload_repository.add_colored_sql('5rygsj4dbw6jt', 
>>>> 1692970157);

>> 11g Docs ---> http://www.oracle.com/pls/db111/homepage

>>

>> Search for "DBMS_WORKLOAD_REPOSITORY"
>> Scroll down to "ADD_COLORED_SQL" Procedure

>>

>> alternatively search for: "COLORED SQL"

>>

>> If someone can't use a search engine they probably shouldn't be
>> allowed to touch a keyboard without adult supervision. <g>

>>

>> If one looks up "Colored SQL" in Morgan's library at www.psoug.org
>> they will find the following:

>>

>> dbms_workload_repository.add_colored_sql(
>> sql_id IN VARCHAR2,
>> dbid IN NUMBER DEFAULT NULL);

>>

>> If you don't know what a sql_id and dbid are the demo clearly shows
>> how to get both.

>>

>> Hope that helps.

>>

>> But the point of my post was a bit light-hearted ... while you won't
>> find colored SQL in other databases ... Oracle now officially has it.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

> 
> Well, I already looked it up on PSOUG and still I think it has nothing to do 
> with syntax highlighting, or the description is not correct, but maybe I'm 
> missing something somewhere.. I think colored_Sql should be something like 
> marked_sql. But I get the point... so was mine. I'll try this for my next 
> 11g demo (next week)
> Tried CCVI yet ? ;-)
> 
> Shakespeare. 

It has zero to do with highlighting. As I said my post was intended to be light-hearted.

That said it is a really nice new 11g feature.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Oct 02 2007 - 18:35:45 CDT