There are a number of relational databases to store data. A relational database contains normalized data stored in tables. Tables contain records and columns. RDBMS makes it easy to work with individual records. Each row contains a unique instance of data for the categories defined by the columns.
RDBMS are used in OLTP applications(e.g. ATM cards) very frequently and sometimes data warehouse may also use relational databases. Please refer to Relational data modeling for details to know how data from a source system is normalized and stored in RDBMS databases.
| RDBMS Name | Company Name |
|---|---|
| Oracle | Oracle Corporation |
| IBM DB2 UDB | IBM Corporation |
| IBM Informix | IBM Corporation |
| Microsoft SQL Server | Microsoft |
| Sybase | Sybase Corporation |
| Terradata | NCR |
These SQL commands are related with Oracle's data dictionary and can be used to get…
important DDL Statements from Oracle like Commit, Rollback, Grant, Revoke etc..
In this section, we will try to explain about important database DROP commands that are…
In this section, we will try to explain about important database DML commands that are…
In this section, we will try to explain about important database ALTER commands that are…
An Oracle database consists of DDL commands, which are useful to create, modify and drop…