I recently learned of some odd behavior using MySQL BETWEEN operator queries, filtering by a DATETIME column. I wrote about this over on Medium so I am sharing the post for any readers here who are interested…
(more…)Database
Dynamic RPAD() Function using a CASE Expression – Oracle SQL Example
I recently wrote a couple of blog posts on the SQL CASE expression with examples in MySQL. As I study and learn more about Oracle SQL, I wanted to apply a CASE expression to the RPAD() character function for dynamic string padding. Continue reading to see an example query…
(more…)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…
(more…)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…
(more…)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.