Webucator's Blog

|

How to choose between a procedure and a function in PL/SQL?

TL;DR

Only use a procedure when a function won’t do the job.


Oracle has been around so long and so many questions have been asked and answered in so many different ways that it can be difficult to find a definitive answer, especially to a best-practices type question like this one.

There are dozens of pages and blog posts explaining the basic differences between PL/SQL functions and procedures:

  1. Functions return a value. Procedures don’t.
  2. Functions are callable (with some restrictions) from within standard SQL statements. Procedures aren’t.

Continue Reading »

|

Simple Python Script for Extracting Text from an SRT File

Watching movies or TV shows in a foreign language is great for learning that language, but it can be challenging. Quick speech, slang, and background noise can all make understanding more challenging. I find it helpful to have subtitles that match the speech, but foreign-language films/shows don’t always have subtitles. Fortunately, you can often find subtitle files (with a .srt extension) at opensubtitles.org. Unfortunately, those files aren’t easy to read, because they are marked up with timestamps and include every sound made (e.g., mobile phone ringing). Continue Reading »

|

The 25 Hottest Technologies in Q2 2016

Based on the number of active StackOverflow posts, the 25 hottest technologies of Q2, 2016 are:

  1. JavaScript – 11.7%
  2. Java – 9.9%
  3. Android – 8.6%
  4. PHP – 7.5%
  5. C# – 7.2%
  6. Python – 6.8%
  7. jQuery – 5.2%
  8. HTML – 5.0%
  9. iOS – 4.3%
  10. CSS – 3.5%
  11. C++ – 3.4%
  12. MySQL – 3.1%
  13. AngularJS – 3.1%
  14. SQL – 2.4%
  15. Swift – 2.3%
  16. Node.Js – 2.1%
  17. R – 2.0%
  18. JSON – 1.8%
  19. Ruby on Rails – 1.7%
  20. ASP.NET – 1.7%
  21. C – 1.5%
  22. SQL Server – 1.5%
  23. Objective-C – 1.4%
  24. .NET – 1.3%
  25. Excel – 1.2%

Continue Reading »