Re: recent drivel posted by Tony Rogerson on his blog

"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. Received on Tue Oct 02 2007 - 17:09:13 CDT