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…(more…)
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…(more…)
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…(more…)
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.
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.
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
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
BETWEEN value range tests, subqueries,
IN() operators, and more. Continue reading to see examples of the MySQL Searched