Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Naga.

Asked: March 02, 2018 - 4:35 pm UTC

Last updated: March 04, 2018 - 4:52 am UTC

Version: 18c

Viewed 1000+ times

You Asked

Hi TOM group, Since yesterday I read the new version of Oracle 18c some of the elements like Analytical functions(As you said calculations), while reading I didn't find any examples to better understand about it like Rank_*...etc. I read the only theory part.Can I get a few examples from you to get better understand.it is great help for me sir, I wanna more interested to learning on 18c, which is an absolutely the great thing to us, a specially Oracle database part programmers.Thanks in advance.

and Connor said...

Analytical functions aren't really new to 18c.

I've got a full video series to step through you analytic SQL, which you can get to here.

https://www.youtube.com/playlist?list=PLJMaoEWvHwFIUwMrF4HLnRksF0H8DHGtt

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.