Oracle

What is Oracle?

• Oracle database is a multi-model database management system.
• Its called as Oracle RDBMS or just Oracle.
• Oracle is a fully salable relational database architecture.

Installing Oracle Database:

• Search oracle 11g release 2 in google search and open the oracle site.

• Accept the license and download the desired software preferred to you PC.

• Open the Oracle 11g folder and click setup.

• Unzips all the files.

• Select the Package and Installation Path.

• Click Next.

• Click Install
• Installs all the files required for the Oracle Installation.

• Set the login password and click next.

• Open Run Sql Command Line.
• To start Database Query.

Oracle Database Commands:

• Enter connect and press enter.
• Enter Username and Password to Connect the database.

Write:

• Create table creates the table with filed names and the type of the field data.

• Insert into used to insert a single row data into the table.

• Inserts all into used to insert a multiple row values into a table.

Read:

• Select is used to get data from the database.

Update:

• Alter used to modify or add or delete the data in the table.
• Alter Modify used to change the datatype of field name or column name

• Alter Add used to add the new column into the table.

• Update used to add the values to specific row data or change the values of specific row data.

• Alter Drop used to delete the column in the table.