POUG voucher – contest


05.07.2017
by Kamil Stawiarski

Contest time!
I had a cool function in my database:

SQL> ;
  1  select object_name, object_type
  2  from user_objects
  3* where object_name like '%POUG%'
SQL> /

OBJECT_NAME		       OBJECT_TYPE
------------------------------ -----------------------
F_GET_POUG_PROMO_CODE	       FUNCTION

When executed, it returned a -15% voucher for POUG conference. And POUG is a REALLY COOL confernece 🙂 Check it out: poug.org

The problem is that I was cleaning my training database and dropped the function by accident.

Fortunately, I have archivelogs and I wrote recently a simple Python script to restore dropped PL/SQL objects (you can find the script in my previous blog post).

The archivelogs can be found here: http://ora-600.pl/poug/f_get_poug_promo_code_archs.tar.bz2

Have fun 😉


Contact us

Database Whisperers sp. z o. o. sp. k.
al. Jerozolimskie 200, 3rd floor, room 342
02-486 Warszawa
NIP: 5272744987
REGON:362524978
+48 508 943 051
+48 661 966 009
info@ora-600.pl

Newsletter Sign up to be updated