# Mocking in Oracle PL/SQL

- Institution: CERN
- Department: IT Lightning Talks (ITLT)
- Speaker: Maciej GRZYBEK
- Year: 2015
- Language: English
- Source: [CERN](https://videos.cern.ch/record/3012302)
- Licence: [CERN](http://copyright.web.cern.ch)
- Who can watch: Teens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

Testing is not very popular in database development, so there are none common approaches how to test software written in database. Surprisingly one of the oldest DB still lacks of appropriate testing approach for its PL/SQL programs. SQLDeveloper's built-in test "framework" is far from excellence, especially it does not cover mocking which is inherent part of testing for any bigger system being developed. This talk will briefly introduce Edition-Based Redefinition by Oracle to be used for mocking..

0:00:00 Slide 1

0:00:48 Slide 2

0:00:54 Slide 3

0:01:16 Slide 4

0:01:22 Slide 5

0:01:38 Slide 6

0:01:42 Slide 7

0:02:15 Slide 8

0:02:25 Slide 9

0:02:48 Slide 10

0:03:19 Slide 11

0:03:33 Slide 12

0:03:41 Slide 13

0:03:46 Slide 14

0:04:02 Slide 15

0:04:20 Slide 16

0:04:34 Slide 17

0:04:47 Slide 18

0:05:05 Slide 19

## Lectures

1. [Mocking in Oracle PL/SQL](https://invisiblenetwork.ai/learn/cern/3012302/be8dd213255d), 7 min (CERN's player)