Browsing Tag
sql
93 posts
True Alphanumeric / natural sorting in MySQL – why is the answer always recursion?
Yesterday I attempted to solve alphanumeric sorting in MySQL and failed. (read that article here) I did get…
SQL ain’t that Scary
Introduction The Stack overflow developer survey ranks SQL as one of the highly desired and admired programming languages.…
Stored Procedure in PL/SQL
Stored Procedure A stored procedure in PL/SQL (Procedural Language/Structured Query Language) is a set of SQL statements that…
List of the best Google Dorks in 2024 for finding SQL injection vulnerabilities and other security issues:
Author: Trix Cyrus Here’s a comprehensive list of the best Google Dorks for finding SQL injection vulnerabilities and…
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL
Introduction This article is based on real problems I had in a production environment in Oracle 11g. Oracle…
🗄️🚀 SQL vs NoSQL: Viability and Comparison
Welcome to our post on the viability and comparison between SQL and NoSQL databases! In this article, we…
Get the whole group where at least one member meets the specified condition #eg36
Below is a table queried from BigQuery database. Its 4th field has comma-separated strings. Use Java to do…
Group and Summarize data, and align to the specified sequence #eg31
Below is temp_data table in Oracle database: LETTER is the foreign key field, which points to temp_ref table’s…
SQL Complete guide for Interview
Structured Query Language or SQL is a standard database language that is used to create, maintain, destroy, update,…
