Medium Cross-post – CodeIgniter 4 CRUD: Read

Storing data is but one part of many in application development. Once data is stored, interested parties will likely want to see it. This is the Read aspect of CRUD – reading (or viewing) the data. Continue reading and see examples using CodeIgniter 4 built-in Model methods…


How to re-order a comma-separated list in Oracle SQL

Suppose you have a comma-separated list composed of numbers and you want it sorted in order from smallest to largest. Continue reading and see a working example I came up with as I continue studying Oracle SQL…


Import CSV file with Oracle SQL Developer

If you’re working with Oracle SQL and need to load CSV data into one of your tables, using Oracle SQL Developer makes this process a breeze. Continue reading to see a simple example and learn how…


Oracle SQL SUBSTR() Character function – Medium cross post

I have been writing several articles about Oracle SQL over on my Medium account. With the Always Free Autonomous Database, having access to the Oracle Database is now easier than ever. In this Medium cross-post I share an article covering the SUBSTR() character function…

Any programmer, SQL professional, or data practitioner knows how much of a part text data is in any workflow. Oftentimes, text and string data only have specific portions that are of interest. Obtaining those key segments can typically be done using character functions.

Like other SQL implementations, Oracle SQL has a range of character functions. In the post, SUBSTR() Character Function – Oracle SQL Example, I cover simple queries for extracting key character values using SUBSTR(). The extracted text data is then used in additional processing queries.

If you aren’t familiar with the SUBSTR() function, learn more about it in this post. For the most part, each SQL dialect has an SUBSTR() function or something comparable so the concepts should easily apply to whatever function is available in the SQL implementation you are working with.

In what crafty ways have you had to use SUBSTR() (or a similar function) in your queries or analysis to extract the character values you needed? I’d love to know of them so please drop a line in the comments. πŸ™‚

Like what you have read? See anything incorrect? Please comment below and thank you for reading!!!

A Call To Action!

Thank you for taking the time to read this post. I truly hope you discovered something interesting and enlightening. Please share your findings here, with someone else you know who would get the same value out of it as well.

Visit the Portfolio-Projects page to see blog post/technical writing I have completed for clients.

To receive email notifications (Never Spam) from this blog (“Digital Owl’s Prose”) for the latest blog posts as they are published, please subscribe (of your own volition) by clicking the β€˜Click To Subscribe!’ button in the sidebar on the homepage! (Feel free at any time to review the Digital Owl’s Prose Privacy Policy Page for any questions you may have about: email updates, opt-in, opt-out, contact forms, etc…)

Be sure and visit the “Best Of” page for a collection of my best blog posts.

Josh Otwell has a passion to study and grow as a SQL Developer and blogger. Other favorite activities find him with his nose buried in a good book, article, or the Linux command line. Among those, he shares a love of tabletop RPG games, reading fantasy novels, and spending time with his wife and two daughters.

Disclaimer: The examples presented in this post are hypothetical ideas of how to achieve similar types of results. They are not the utmost best solution(s). The majority, if not all, of the examples provided, are performed on a personal development/learning workstation-environment and should not be considered production quality or ready. Your particular goals and needs may vary. Use those practices that best benefit your needs and goals. Opinions are my own.

MySQL Searched CASE Expression – with examples

During many decision-making phases in programming code (conditional logic), there are times execution depends on several different factors. Multiple conditional tests are powerful and constraining, oftentimes requiring more than one test to be passed in order for program flow to proceed. For MySQL (and standard SQL in general) the CASE expression is used for IF/THEN/ELSE conditional logic. The post, MySQL Simple CASE Expression – with examples, covered Simple CASE queries which are essentially equality tests. MySQL Simple CASE is but one variant of 2, with the other being a MySQL Searched CASE Expression.  A MySQL Searched CASE Expression can have multiple conditional tests in each WHEN clause. These conditional tests can be AND/OR comparisons, BETWEEN value range tests, subqueries, IN() operators, and more. Continue reading to see examples of the MySQL Searched CASE Expression…

[Keep reading for more MySQL database and Python/PHP-centric content >>>]