Matěj Černý
  • Bluesky
  • LinkedIn
  • Nostr
  • X
  • Čeština
  • Bluesky
  • LinkedIn
  • Nostr
  • X
  • Čeština

Day: May 3, 2018

2018-05-03

Oracle 12c / Top N rows, pagination

In older versions, limiting sorted data by the number of rows had to be implemented using a nested query. This first sorted the table, and only then was it possible to filter by count.

Matěj Černý
Matěj Černý

Big Data

  • Apache Spark / CSV file
  • Apache Spark / Dataframe API vs. SQL

PL/SQL by Examples

  • Anonymous Block and Branching
  • Scalar Data Types
  • Composite Data Types
  • FOR and WHILE loop
  • Procedures and Functions
  • Package
  • Exceptions
  • Savepoints
  • Object
  • Inheritance and Polymorphism

Oracle 12c

  • Querying from an associative array
  • User-defined function in the WITH clause
  • Top N rows, pagination
  • Cheat sheet / Oracle DDL operations

Links

  • Petr Stříbný
  • Josef Strzibny
© Matěj Černý