Using SQL like Excel
https://www.youtube.com/watch?app=desktop&v=DLLyG7OC2Qo

Using SQL like Excel

Andrea Salzano Andrea Salzano

Andrea Salzano

Oracle PL/SQL Developer at Lottomatica S.p.A.

发布日期: 2024年7月5日
+ 关注

SQL allow you to manage a result set as a spreadsheet. It is possible using the MODEL clause.

Oracle introduced MODEL in 10g version [1].

It is simple to visualize how MODEL works, if you understand the relation between SQL and the spreadsheet.

How you can see in the following picture

  • "PARTITION BY", correspond to the sheet
  • "DIMENSION BY", correspond to the rows (the numbers in the sheet)
  • "MEASURES", correspond to the columns (the letters in the sheet)
  • "RULES", correspond to the functions






[1] https://technology.amis.nl/wp-content/uploads/2004/12/10gr1-twp-bi-dw-sqlmodel-131067.pdf

要查看或添加评论，请登录

Andrea Salzano的更多文章

  • 2 physical concepts in Oracle database
    2024年7月25日

    2 physical concepts in Oracle database

    It could be strange, but yes, there are 2 concepts that came from physic that you can apply to your oracle database…

  • How to rescue data after a mistake
    2024年7月16日

    How to rescue data after a mistake

    Oracle give you the opportunity to recover data also if you delete them or dropped the table. Here 2 simple example…

  • Using SQL like Excel - First example
    2024年7月10日

    Using SQL like Excel - First example

    In my previous post, I have shown the relation between SQL MODEL clause and an Excel spreadsheet. In this post, you can…

  • MATCH_RECOGNIZE order of application
    2024年6月26日

    MATCH_RECOGNIZE order of application

    Starting 12c, Oracle introduced THE MATCH_RECOGNIZE analytic function to recognize patterns. IF you are NEW TO this…

  • Analytic Function preserve the partitioning
    2021年7月21日

    Analytic Function preserve the partitioning

    Analytic Functions are great. They are SQL standard so all databases implement them.

  • ITOUG Tech Day 2019 (Milano)
    2019年1月31日

    ITOUG Tech Day 2019 (Milano)

    Il primo giorno del Tech Day 2019 a Milano, si è concluso. Alla grande dire.

    2 条评论
  • ITOUG 2019: Oracle, Mediamente, R1
    2018年12月13日

    ITOUG 2019: Oracle, Mediamente, R1

    L'ITOUG event che si terrà il 30/Gennaio/2019 a Milano ed il 01/Febbraio/2019 a Roma è stato possibile grazie a tre…

  • ITOUG 2019: ancora insieme
    2018年11月22日

    ITOUG 2019: ancora insieme

    Ormai ci abbiamo preso gusto. E' bello iniziare un nuovo anno (più o meno :) sapendo che poi sarà tutto in discesa.

  • ITOUG 2019 Thech Days
    2018年10月10日

    ITOUG 2019 Thech Days

    Finalmente ci siamo. il 30 Gennaio ed il 1 Febbraio IOTUG organizzerà un nuovo evento.

  • Blocking session
    2018年8月16日

    Blocking session

    Some time ago, I wrote a post on how to show a chain of blocked sessions. In this days Kaley Crum wrote a new version…

社区洞察

其他会员也浏览了