Re: recent drivel posted by Tony Rogerson on his blog


"Tony Rogerson" <tonyrogerson@xxxxxxxxxx> wrote in message news:fdns2m$ln9$1$8300dec7@xxxxxxxxxxxxxxxxxxx
Hi Richard,

Click on the 2 day dev link (html) and it takes you here http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28843/toc.htm which is high level index, click on master index - I want a list of all topics so I can scroll down.

Search is only useful if you know the correct terminolgy to search on.

Take an example, in SQL Server we have what's called 'Common Table Expression'; searching for that on the oracle help does not yeild anything similar in oracle yet I know there is something, so, what I need is a full scrollable index of topics so I can find what I'm looking for.

It does all rather suggest you're perfectly suited to working only with Microsoft products ;)

Absolutely - which is probably why I moved with SQL Server rather into Oracle when I had the choice.

I prefer to concentrate on providing a solution to the business problem rather than concentrating on being syntax clever.

I suppose if this is all you are used to (the oracle documentation structure) then I guess that is all you know - it's only until you use something better that you realise how much better life is - a bit like the introduction of colour coded syntax that helps you detect when you've spelt slect wrong...


Hi Tony

With my admittedly limited knowledge of SQL Server, I believe that a Common Table Expression is used in conjunction with the WITH clause. A search in the Oracle documentation of 'With clause' listed a hell of a lot of results that look a lot like SQL Server Common Table Expressions.

Ummm, just how hard did you try ?

Really ?

Perhaps Oracle has colour coded syntax after all :)

Cheers

Richard

.

Relevant Pages

  • Re: recent drivel posted by Tony Rogerson on his blog
    ... Take an example, in SQL Server we have what's called 'Common Table Expression'; searching for that on the oracle help does not yeild anything similar in oracle yet I know there is something, so, what I need is a full scrollable index of topics so I can find what I'm looking for. ... I prefer to concentrate on providing a solution to the business problem rather than concentrating on being syntax clever. ... I suppose if this is all you are used to then I guess that is all you know - it's only until you use something better that you realise how much better life is - a bit like the introduction of colour coded syntax that helps you detect when you've spelt slect wrong... ...
    (comp.databases.oracle.server)
  • Re: SQL Question
    ... [Oracle doesn't support CTEs.] ... WITH (SELECT class FROM lib1/file1 ... SELECT class FROM lib2/file1) AS a ... and can appear multiple times (thus the 'Common' part of CTE). ...
    (comp.sys.ibm.as400.misc)
  • Re: Any new analytic SQL Features in SQL2005?
    ... > Common Table Expressions introduced in SQL2005 is realy great thing. ... > Now I wonder are there plan to add any new analytic SQL features which ... in Oracle will be pushed to the CLR or sql kludges developed. ...
    (microsoft.public.sqlserver.programming)
  • Re: high through put system
    ... ANALYZE is a bit dated - and it's the most common answer when asked how to create statistics... ... hire people with Oracle 7 experience just because the of attitude ...
    (comp.databases.oracle.server)
  • Oracle Knowledge [was: Re: high through put system]
    ... that ANALYZE is a bit dated - and it's the most common answer when asked how to create statistics... ... The group I have seen is that type which did 3 days Oracle in their education and claims "I know Oracle". ...
    (comp.databases.oracle.server)