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

Day: May 4, 2017

2017-05-04

PL/SQL by Example / Exceptions

As already indicated in the introduction, the part of the block introduced by the keyword EXCEPTION is used for catching program runtime errors.

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ý