While working with Oracle database, in day to day life,we use many types of SQL commands. In fact SQL commands are really universal in nature. Today, let us learn some of the most commonly used SQL commands in Oracle.

In Oracle we work with many types of datatypes. Some of the most popular datatypes are as follows:

The word database can be best defined as a coherent collection of data with some inherent meaning, designed, build and populated with data for a specific purpose.

The most significant characteristics of a relational DBMS models are

In a multi environment, an RDMS engine capable of functioning on a multi user operating system is used. Now, multiple users’ request for table data will be responded to by the RDMS engine.

The person who is responsible for administrating all of Oracle’s resources on the hard disk drive and allows the user to access these resources is mainly known as Oracle Database Administrator (ODBA).

The Oracle DBA can compile and execute SQL sentences issued by a user. If the SQL sentences are unsuccessful, the Oracle returns an appropriate error message to the user.

SQL * Plus is made up of two distinct parts. These are (a) Interactive SQL (b) PL/SQL. Interactive SQL is designed to create, access and maintain all data structures like tables, indexes etc.

An oracle form allows us to create a data entry screen along with suitable menu object. The Oracle form tools handles data gathering and data validation of a commercial application.

Report writer allows programmers to prepare innovative reports using data from the Oracle Structures like tables, views etc.

Some of the data can be better represented in the form of graphs. The Oracle Graphics Tools allows programmers to prepare graphs using data forms Oracle Structures like tables, view etc.

Oracle provides an Interactive SQL tool i.e. SQL * Plus, which allows users to enter the ANSI SQL sentences and pass them to the DBA for execution.

The methods via which you can construct SQL sentences and pass them to the DBA are as follows: 

The most significant data types that a cell can hold in Oracle Developer 2000 are as follows:

In Oracle two dimension Matrix can be easily done by communicating with the DBA using the natural language of the DBA, namely ISQL.

The command or in other words the syntax for creating tables in Oracle is

Sometimes we have to create a table from another table. If the source table from which the Target table is being created, has records in it then the target table is populated with these records as well.

You can easily insert data into tables in Oracle by writing the below given SQL Query.