ORACLE : LAB SESSION

Aim: Getting Familiar with Oracle and Oracle SQL Developer, Creating Table, Inserting Data into Table and Getting Familiar with View Topics: 1. What is Oracle and Oracle SQL Developer? 2. Oracle and SQL Developer Installations 3. SQL Commands vs. PL/SQL Blocks 4. Most common used data types in Oracle 5. Creating connection to Oracle Database in SQL Developer 6. What is view and how to create it? • What is Oracle? Oracle is a highly flexible RDBMS that manages storing data and allows users to modify and retrieve data. One of the main advantages of using Oracle specifically in companies is its wide range of professional financial and enterprise applications, which are compatible with Oracle database. Oracle also supports the implementation of Distributed Databases. • What is Oracle SQL Developer? Oracle SQL Developer is an integrated development environment for working with SQL in Oracle databases. • Oracle and SQL Developer Installations: To start working, you need to install both Oracle as well as Oracle SQL Developer. For installing Oracle, go to Oracle website, create an account and then install one of the versions available for Oracle. Click here to find the list of Oracle versions available on Oracle website. You also need to download SQL Developer through this link and then install it on your system.