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

Day: January 11, 2018

2018-01-11

Oracle 12c / Querying from an associative array

To use an array in SQL queries, it was previously necessary to create a “stored” type on the SQL server side and assign the appropriate rights… Read more

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ý