recent drivel posted by Tony Rogerson on his blog
This is a discussion on recent drivel posted by Tony Rogerson on his blog within the Oracle Database forums, part of the Database Server Software category; --> "DA Morgan" <damorgan@psoug.org> schreef in bericht news:1191339240.206371@bubbleator.drizzle.com... > Richard Foote wrote: > >> Perhaps Oracle has colour coded syntax ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 07:44 AM
| ||||
| ||||
 Re: recent drivel posted by Tony Rogerson on his blog "DA Morgan" <damorgan@psoug.org> schreef in bericht news:1191339240.206371@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('5rygsj4d bw6jt', > 1692970157); And who needs documentation for that? Parameter values like 5rygsj4dbw6jt and 1692970157 are almost self-documenting...... But it does not seem to have anything to do with color coded syntax.... Maybe you could use CCVI Shakespeare > > But I suspect it is technically well beyond the capabilities of > someone that can't handle a search engine. > -- > Daniel A. Morgan > University of Washington > damorgan@x.washington.edu (replace x with u to respond) > Puget Sound Oracle Users Group > www.psoug.org      |
|
02-26-2008, 07:44 AM
| |||
| |||
| Re: recent drivel posted by Tony Rogerson on his blog "DA Morgan" <damorgan@psoug.org> schreef in bericht news:1191356171.450453@bubbleator.drizzle.com... > Shakespeare wrote: >> "DA Morgan" <damorgan@psoug.org> schreef in bericht >> news:1191339240.206371@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('5rygsj4d bw6jt', >>> 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@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. |
|
02-26-2008, 07:44 AM
| |||
| |||
| Re: recent drivel posted by Tony Rogerson on his blog "DA Morgan" <damorgan@psoug.org> schreef in bericht news:1191356284.554952@bubbleator.drizzle.com... > Shakespeare wrote: >> "DA Morgan" <damorgan@psoug.org> schreef in bericht >> news:1191342473.587093@bubbleator.drizzle.com... >>> Shakespeare wrote: >>>> "DA Morgan" <damorgan@psoug.org> schreef in bericht >>>> news:1191286464.480000@bubbleator.drizzle.com... >>>>> Shakespeare wrote: >>>>>> <sybrandb@hccnet.nl> schreef in bericht >>>>>> news:6obuf3pljqn6v5ma6gkfhc7qlg9n1b6l6p@4ax.com... >>>>>>> Please look at >>>>>>> http://sqlblogcasts.com/blogs/tonyro...ve-it-bad.aspx >>>>>>> >>>>>>> >>>>>>> HE DOESN'T EVEN KNOW HOW TO USE http://tahiti.oracle.com >>>>>>> >>>>>>> What a yoke Mr. Rogerson is, self-appointed 'expert'! >>>>>>> >>>>>>> -- >>>>>>> Sybrand Bakker >>>>>>> Senior Oracle DBA >>>>>> I remember a short while ago, someone commented on DA's blog about >>>>>> not having the possibility to post comments there. As far as I can >>>>>> see, mr. Rogerson has a comment link. So please go fight your wars >>>>>> over there. >>>>>> >>>>>> Shakespeare >>>>> The intent of what I post is to get information out the the community. >>>>> Not to provide a competitor to this usenet group or OTN or others such >>>>> as Tom Kyte who more than adequately fulfill that mission. >>>>> >>>>> Almost all blogs currently run on mySQL and the Oracle Users Group >>>>> does not want to host unless the blog software is based on APEX. >>>>> Anyone >>>>> have the code and want to donate it please let me know. >>>>> -- >>>>> Daniel A. Morgan >>>>> University of Washington >>>>> damorgan@x.washington.edu (replace x with u to respond) >>>>> Puget Sound Oracle Users Group >>>>> www.psoug.org >>>> Daniel, >>>> >>>> this post was not meant to criticize your BLOG, it was about people >>>> complaining they could not make comments there. If they want to make >>>> comments on BLOG's, and if they can on Tony Rogersons blog, why take >>>> the whole conversation to CDOS? >>>> >>>> BTW: a Blog on APEX might be a good idea... >>>> >>>> Shakespeare >>> I am working with another Oracle Ace, Eddie Award, to either find one >>> or write one. >>> -- >>> Daniel A. Morgan >>> University of Washington >>> damorgan@x.washington.edu (replace x with u to respond) >>> Puget Sound Oracle Users Group >>> www.psoug.org >> >> Ah, and who stated that it's not polite to change people's names in >> newsgroups? <g> >> >> Shakespeare > > Worse than a typo ... a lack of proof reading. I originally wrote > Ace award winner and then reworked the sentence. Thanks (grumble > grumble) for catching it. > -- > Daniel A. Morgan > University of Washington > damorgan@x.washington.edu (replace x with u to respond) > Puget Sound Oracle Users Group > www.psoug.org As I said looooong time ago: what's in a name? Shakespeare |
|
02-26-2008, 07:44 AM
| |||
| |||
| Re: recent drivel posted by Tony Rogerson on his blog Shakespeare wrote: > "DA Morgan" <damorgan@psoug.org> schreef in bericht > news:1191356171.450453@bubbleator.drizzle.com... >> Shakespeare wrote: >>> "DA Morgan" <damorgan@psoug.org> schreef in bericht >>> news:1191339240.206371@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('5rygsj4d bw6jt', >>>> 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@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@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |
|
02-26-2008, 07:44 AM
| |||
| |||
| Re: recent drivel posted by Tony Rogerson on his blog Shakespeare wrote: > "DA Morgan" <damorgan@psoug.org> schreef in bericht > news:1191356284.554952@bubbleator.drizzle.com... >> Shakespeare wrote: >>> "DA Morgan" <damorgan@psoug.org> schreef in bericht >>> news:1191342473.587093@bubbleator.drizzle.com... >>>> Shakespeare wrote: >>>>> "DA Morgan" <damorgan@psoug.org> schreef in bericht >>>>> news:1191286464.480000@bubbleator.drizzle.com... >>>>>> Shakespeare wrote: >>>>>>> <sybrandb@hccnet.nl> schreef in bericht >>>>>>> news:6obuf3pljqn6v5ma6gkfhc7qlg9n1b6l6p@4ax.com... >>>>>>>> Please look at >>>>>>>> http://sqlblogcasts.com/blogs/tonyro...ve-it-bad.aspx >>>>>>>> >>>>>>>> >>>>>>>> HE DOESN'T EVEN KNOW HOW TO USE http://tahiti.oracle.com >>>>>>>> >>>>>>>> What a yoke Mr. Rogerson is, self-appointed 'expert'! >>>>>>>> >>>>>>>> -- >>>>>>>> Sybrand Bakker >>>>>>>> Senior Oracle DBA >>>>>>> I remember a short while ago, someone commented on DA's blog about >>>>>>> not having the possibility to post comments there. As far as I can >>>>>>> see, mr. Rogerson has a comment link. So please go fight your wars >>>>>>> over there. >>>>>>> >>>>>>> Shakespeare >>>>>> The intent of what I post is to get information out the the community. >>>>>> Not to provide a competitor to this usenet group or OTN or others such >>>>>> as Tom Kyte who more than adequately fulfill that mission. >>>>>> >>>>>> Almost all blogs currently run on mySQL and the Oracle Users Group >>>>>> does not want to host unless the blog software is based on APEX. >>>>>> Anyone >>>>>> have the code and want to donate it please let me know. >>>>>> -- >>>>>> Daniel A. Morgan >>>>>> University of Washington >>>>>> damorgan@x.washington.edu (replace x with u to respond) >>>>>> Puget Sound Oracle Users Group >>>>>> www.psoug.org >>>>> Daniel, >>>>> >>>>> this post was not meant to criticize your BLOG, it was about people >>>>> complaining they could not make comments there. If they want to make >>>>> comments on BLOG's, and if they can on Tony Rogersons blog, why take >>>>> the whole conversation to CDOS? >>>>> >>>>> BTW: a Blog on APEX might be a good idea... >>>>> >>>>> Shakespeare >>>> I am working with another Oracle Ace, Eddie Award, to either find one >>>> or write one. >>>> -- >>>> Daniel A. Morgan >>>> University of Washington >>>> damorgan@x.washington.edu (replace x with u to respond) >>>> Puget Sound Oracle Users Group >>>> www.psoug.org >>> Ah, and who stated that it's not polite to change people's names in >>> newsgroups? <g> >>> >>> Shakespeare >> Worse than a typo ... a lack of proof reading. I originally wrote >> Ace award winner and then reworked the sentence. Thanks (grumble >> grumble) for catching it. >> -- >> Daniel A. Morgan >> University of Washington >> damorgan@x.washington.edu (replace x with u to respond) >> Puget Sound Oracle Users Group >> www.psoug.org > > As I said looooong time ago: what's in a name? > > Shakespeare And here was thinking I was the ancient one. <g> -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |
|
02-26-2008, 07:44 AM
| ||||
| ||||
| Re: recent drivel posted by Tony Rogerson on his blog "DA Morgan" <damorgan@psoug.org> schreef in bericht news:1191368132.302991@bubbleator.drizzle.com... > Shakespeare wrote: >> "DA Morgan" <damorgan@psoug.org> schreef in bericht >> news:1191356171.450453@bubbleator.drizzle.com... >>> Shakespeare wrote: >>>> "DA Morgan" <damorgan@psoug.org> schreef in bericht >>>> news:1191339240.206371@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('5rygsj4d bw6jt', >>>>> 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@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@x.washington.edu (replace x with u to respond) > Puget Sound Oracle Users Group > www.psoug.org Highlighthearted...... Shakespeare |
Linear Mode
