SQL (Structured Query Language) is a language understood by most modern databases. It is an ANSI (American National Standard Institute) standard language which is used to manipulate databases.
Select statement is used to retrieve data stored in a database. It article describes a full-fledged select statement including where, group by, having and order by clause.
SQL Joins are used to retrieve records from two or more tables which have a relationship. This articles talks about different types SQL Joins like Equijoin, Non-Equijoin Inner Join and Outer Join.
SQL Subquery is a query within another SQL query. It is a mechanism implemented on a Select statement where the output returned by the subquery is used by the outer query to produce the final result.
DDL is a sub-language of SQL. They are used create and manipulate objects in a database. The DDL statements includes CREATE, ALTER, DROP, TRUNCATE and RENAME.
Constraints are used to impose certain rules on columns to avoid invalid data entry into the table. If any of the constraint is violated the operation fails.
DML is a sub-language of SQL. It is used to manipulate data stored in a table. The DML operations include insertion, updation and deletion of data stored in a table.
Any transaction on a database table is made persistent in the respective tables only after a commit command is issued after the transaction is made. This article provides an overview of these TCL...
Data Control Language (DCL) is a sub-language of SQL used for administrative purposes like create and manage database users and roles; and to grant/revoke privileges to database objects.
SQL provides the START WITH and CONNECT BY clauses to extract data recursively from a table. This article shows the usage of these clauses with the help of suitable examples.
Learn how to create and use Views in a Database. Views are database objects that are a logical subset of data which are based on one or more tables. Views are primarily used to hide the table struc..
Database Index is used to arrange records in a proper manner in database using references to the data. It helps in the searching of records whenever a complex Select query is fired.
Oracle Database allows developers to create their own datatypes and use them in column of database tables. These user-defined datatypes are called as 'Type'.
A sequence is used to auto-generate numbers in ascending or descending order which can serve as a primary key or a part of it (in case of composite key).
Synonyms are database objects used to provide duplicate names to existing objects in the database. It is just an alternate name used to hide the original name of the object.
The concept of condition beans enables Spring to restrict the creation of any bean depending on the evaluation of a condition. These beans get created only when a preset condition is evaluated as true