Hey everyone, I’m creating a dedicated page of ‘Friend links‘ for all of my Medium first articles and blogs. Continue reading to learn more and how to gain access to them…
(more…)Oracle SQL
CSV – SQL Import/Export Compilation
CSV or SQL? SQL or CSV? How about together? Without a doubt, CSV’s are one of the most common and familiar data interchange formats. Importing and exporting CSV data into or out of an SQL database is a staple process in most every data workflow. I’ve written numerous blog posts on both importing and exporting CSV data in an SQL environment. In this post, I am including all of these specific posts (as of the time of writing) in one easy-to-read and centralized location…
(more…)Create Table Structure From Existing Table in Oracle SQL
Do you need the same table structure as an existing table in your database, but empty of rows? Oracle SQL’s CREATE TABLE AS statement achieves this easily. Continue reading and learn how with a simple example…
(more…)Export Query Results to CSV with SQL Developer
One of the most universal data interchange formats in the world is the CSV file. Data professionals use CSV’s without a thought. Equally, those not even in the ‘data field’ use CSV’s on a daily basis. Do you have the SQL query results for that report and need to share them in CSV format? Using the Oracle SQL Developer IDE, it is a breeze…
(more…)SQL INSTR() Function – Medium Cross Post
Character and text data are such an integral component of data that most all programming languages provide many functions, constructs, and even libraries to help process text data. I recently used the Oracle SQL INSTR() function in some text-parsing queries. However, these queries were not standalone INSTR() only. INSTR() is also quite powerful as a parameter for other string functions, namely SUBSTR(), in this example. Continue reading to learn more…
(more…)