Command injection is basically injection of operating system commands to be executed through a web-app. The purpose of the command injection attack is to inject
Code injection is the malicious injection or introduction of code into an application. The code introduced or injected is capable of compromising database integ
There are two CREATE statements available in SQL: CREATE DATABASE CREATE TABLE CREATE DATABASE A Database is defined as a structured set of data. So, in SQL the
As explained in this article, an SQL Injection attack, or an SQLi, is a way of exploiting the underlying vulnerability of an SQL statement by inserting nefariou
This article explains how to test whether a website is safe from SQL injection using the SQLMAP penetration testing tool. What is SQL Injection? SQL Injection i
Aliases are the temporary names given to table or column for the purpose of a particular SQL query. It is used when name of column or table is used other than t
SQL injection is a code injection technique, used to attack data driven applications, in which malicious SQL statements are inserted into an entry field for exe
Division is typically required when you want to find out entities that are interacting with all entities of a set of different type entities. The division opera
SQL injection is a technique used to exploit user data through web page inputs by injecting SQL commands as statements. Basically, these statements can be used
LISTAGG function in DBMS is used to aggregate strings from data in columns in a database table. It makes it very easy to concatenate strings. It is similar to c
Constraints are the rules that we can apply on the type of data in a table. That is, we can specify the limit on the type of data that can be stored in a partic
Like in other programming languages, SQL also has certain datatypes available. A brief idea of all the datatypes are discussed below. 1. Binary Datatypes : T
As is any programming languages comments matter a lot in SQL also. In this set we will learn about writing comments in any SQL snippet. Comments can be written
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields
The Common Table Expressions (CTE) were introduced into standard SQL in order to simplify various classes of SQL Queries for which a derived table was just unsu
Sequence is a set of integers 1, 2, 3, … that are generated and supported by some database systems to produce unique values on demand. A sequence is a user de
Query Processing includes translations on high level Queries into low level expressions that can be used at physical level of file system, query optimization an
A role is created to ease setup and maintenance of the security model. It is a named group of related privileges that can be granted to the user. When there are
What are Transactions? Transactions group a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks
In this article, we will see how to create, delete and uses of the INDEX in the database. An index is a schema object. It is used by the server to speed up the
SQL | ALL and ANY SOME operator evaluates the condition between the outer and inner tables and evaluates to true if the final result returns any one row. If not
Sometimes we may require tuples from the database which match certain patterns. For example, we may wish to retrieve all columns where the tuples start with the
The EXISTS condition in SQL is used to check whether the result of a correlated nested query is empty (contains no tuples) or not. The result of EXISTS is a boo
PL/SQL is a block-structured language that enables developers to combine the power of SQL with procedural statements. A stored procedure in PL/SQL is nothing bu
SQL(Structured Query Language) SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Stand
