How ORDER BY is restricted in GROUP BY queries

As always, I am sharing what I learn here on my blog. As I continue to study SQL, the language never ceases to amaze me with those little intricacies you don’t necessarily learn of unless you are bitten by them, or through intentional study. Luckily, my case is the latter of the 2. I’m referring to the ORDER BY clause when used in GROUP BY queries. Continue reading for more information.


How to Rename an SQL Table

There are a number of reasons why you may need to rename a table in your SQL Database. Whatever the case may be, the process is super-easy. In this post, I share 2 different ways you can rename an existing table in the Oracle Database. Continue reading and learn how…


How to Insert Data using Oracle SQL Developer

The INSERT DML command introduces new rows of data into an SQL table. INSERT is under the Create domain of the CRUD acronym. When using the Oracle SQL Developer IDE, instead of writing an INSERT INTO command, there are visual elements within the IDE interface which help facilitate an INSERT operation. Continue reading to learn how with a simple example…


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.