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

Day: March 24, 2016

2016-03-24

PL/SQL by Example / Composite Data Types

The topic of structures capable of holding multiple values is somewhat extensive due to the division of the Oracle database into an SQL part and a procedural PL/SQL extension. Also, individual database versions bring slight differences in the use of given structures.

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ý