Testing with utPLSQL

I had two special guests on this months Office Hours. Jacek Gebal and Samuel Nitsche got given the ultimate challenge. To take an unseen application code base, and build a suite of unit tests around it without knowing the full details of the application requirements, the data model etc.
Watch this session to see how they did, and see the utPLSQL tool in action during live unscripted demos.
blog: connor-mcdonald.com
twitter: / connor_mc_d
All other social media channels here: linktr.ee/connor
Are you serious? A free Oracle database forever ?!?!?!?! Indeed!
www.oracle.com/cloud/free
Music: Night Owl (Broke For Free), Dyalla
#oracle #testing #utplsql

[@albertogonzalez5114]

great session, thanks so much!

[@DerPesse]

Thank you so much for having us, Connor!
Since this was an experiment, Jacek and I would really appreciate feedback:
- Did you like the format?
- Was it valuable for you?
- Was it fun?
- Did you learn something new?
- Is it (the format, live-coding without a lot of preparation) something you'd like to see again/more?
Reach out to us via social media

[@kowal7907]

Hi, the format and the content are really valuable. Besides substantive informations about the programming (testing in this case), we can observe your great workshop. And there is a question to you, Samuel: what text editor do you use on this film, to edit and launch PL/SQL code?

[@kowal7907]

OK, there was no question :) I found it in comments under another film on YT. It's "DataGrip von JetBrains".

[@DerPesse]

@@kowal7907 Thank you! Nice to hear it was valuable for you. Yes, the IDE is JetBrains DataGrip. It has its flaws but I like the "feel" of it and also the incredibly powerful intellisense (when the caches are up-to-date)

[@SteveMoore1969]

I liked the format.
You showcased utPLSQL as a very simple to use product which I was not expecting.

[@DerPesse]

@@SteveMoore1969 Awesome feedback, thank you! Let us know if you try it out!

[@s3rg3y666]

Thanks Connor, it's very interesting... But, I've a question (maybe not related with video content), ¿which PL/SQL editor are you using in the video?.. I'm not able to idenfy it and I'll like to test it. Thanks again...

[@fidelfs]

He was using DataGrip from Jetbrains. It is an agnostic database tool. It is not difficult to learn, but you have to be open to surprises. What you know in Oracle has a different name some times. Functions and Procedures are found under "Routines".

[@the_qa_guy]

Dropping the truths in this video:
"Testing is (also) about getting the code into a testable state"
"Make sure that your tests can fail"

[@ketthos]

Hi, can i ask you the tool you used? SQL Developer? What about SQL Developer Unit Test default tool? Thanks

[@fidelfs]

It is called DataGrip from Jetbranins.

[@pepealexandre]

After SQL Developer 21.4 the Unit Testing feature is desupported: "Oracle recommends using the SQL Developer extension for utPLSQL"

[@santoshpanigrahi205]

After 23 minute I am leaving this. Good with DBMS_OUTPUT and IDE unit test ..