Oracle was the first company to release a product that used the English-based Structured Query Language or SQL. This language allows end users to manipulate information of table(primary database object). To use SQL you need not to require any programming experience. SQL is a standard language common to all relational databases. SQL is database language used for storing and retrieving data from the database. Most Relational Database Management Systems provide extension to SQL to make it easier for application developer.
A table is a primary object of database used to store data. It stores data in form of rows and columns.
SQL*Plus is an Oracle tool (specific program ) which accepts SQL commands and PL/SQL blocks and executes them. SQL *Plus enables manipulations of SQL commands and PL/SQL blocks. It also performs additional tasks such as calculations, store and print query results in the form of reports, list column definitions of any table, access and copy data between SQL databases and send messages to and accept responses from the user. SQL *Plus is a character based interactive tool, that runs in a GUI environment. It is loaded on the client machine.
To communicate with Oracle, SQL supports the following categories of commands:
1. Data Definition Language Create, Alter, Drop and Truncate
2. Data Manipulation Language Insert, Update, Delete and Select
3. Transaction Control Language Commit, Rollback and Save point
4. Data Control Language Grant and Revoke
Before we take a look on above-mentioned commands we will see the data types available in Oracle.
A table is a primary object of database used to store data. It stores data in form of rows and columns.
SQL*Plus is an Oracle tool (specific program ) which accepts SQL commands and PL/SQL blocks and executes them. SQL *Plus enables manipulations of SQL commands and PL/SQL blocks. It also performs additional tasks such as calculations, store and print query results in the form of reports, list column definitions of any table, access and copy data between SQL databases and send messages to and accept responses from the user. SQL *Plus is a character based interactive tool, that runs in a GUI environment. It is loaded on the client machine.
To communicate with Oracle, SQL supports the following categories of commands:
1. Data Definition Language Create, Alter, Drop and Truncate
2. Data Manipulation Language Insert, Update, Delete and Select
3. Transaction Control Language Commit, Rollback and Save point
4. Data Control Language Grant and Revoke
Before we take a look on above-mentioned commands we will see the data types available in Oracle.
No comments:
Post a Comment