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

Day: April 5, 2016

2016-04-05

PL/SQL by Example / Procedures and Functions

Named blocks include procedures and functions. These can be called repeatedly. The declarative section within both types of methods is indicated by the keyword IS, which is mandatory. Further division into the executable part and the exception handling part is identical to anonymous blocks.

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ý