Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: recent drivel posted by Tony Rogerson on his blog

Re: recent drivel posted by Tony Rogerson on his blog

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 3 Oct 2007 11:37:41 +0200
Message-ID: <470362ee$0$243$e4fe514c@news.xs4all.nl>

"DA Morgan" <damorgan_at_psoug.org> schreef in bericht news:1191368132.302991_at_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

Highlighthearted......

Shakespeare Received on Wed Oct 03 2007 - 04:37:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US