Browsing Tag
sql
81 posts
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,…
Mastering SQL: Best Practices for Developers
SQL is pivotal in managing relational databases. Adhering to best practices in SQL coding is essential for optimizing…
Transpose Multiple Columns into One Row in Each Group #eg15
Problem description & analysis We have a database table STAKEHOLDER that has data as follows: We are trying…
