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… Read More
Tag Archives: SQL-basics
The data type of a column can be defined as basically what type of data format in which each cell will store the data –… Read More
An index is a schema object. It is used by the server to speed up the retrieval of rows by using a pointer. It can… Read More
In this article, we’ll be discussing Data Definition Language, Data Manipulation Language, Transaction Control Language, and Data Control Language. DDL (Data Definition Language) :… Read More
Sequence is a set of integers 1, 2, 3, … that are generated and supported by some database systems to produce unique values on demand.… Read More
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… Read More
The SQL WITH clause was introduced by Oracle in the Oracle 9i release 2 database. The SQL WITH clause allows you to give a sub-query… Read More
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.… Read More
Comments are used to explain sections of SQL statements or to prevent SQL statements from being executed. As is any programming language comments matter a… Read More
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… Read More
Structured Query Language is a standard Database language which is used to create, maintain and retrieve the relational database. Following are some interesting facts about… Read More
