Contents

1. Introduction To Oracle Architecture

1. Introduction

2. Databases

3. Instances

4. Memory Structures of an Instance

5. Background Processes

6. External Structures

7. Data Blocks, Extents and Segments

2. Data Type

1. Introduction

2. Variables

3. Constants

4. Data Types

3. Queries

1. Introduction of SQL

2. Select Command

3. Operators

Solved Programs

4. SQL Functions

1. Introduction

2. Types of Functions

3. The Dual Table

4. Nested Functions

5. Date Formats

5. Joins

1. Introduction

2. Types of Joins

3. Operators

6. Subqueries and Correlated Query

1. Introduction

2. Using a Subquery to Select Data

3. Subquery Search Conditions

4. Correlated Subqueries

7. DML and TCL Statements

1. Introduction

2. TCL Commands

8. Locks in Oracle

1. Introduction

2. Locking

3. Types of Locks

4. Deadlocks

9. DDL Statements and Users

1. The Data Definition Language

2. Assigning Privileges

3. Creating Users

10. Table

1. Introduction

2. Creating a Table

3. Constraints   

Solved Programs

11. Oracle Objects

1. Introduction

2. Indexes

3. Views

4. Sequences

5. Synonyms

12. Cursor

1. What is a Cursor?

2. Types of Cursor

3. Cursor Attributes

4. Cursor for Loop

5. Parameterized Cursors

6. Cursor Variables

Solved Programs

13. PL/SQL

1. Introduction to PL/SQL

2. Advantages of PL/SQL

3. PL/SQL Character Set

4. Executing PL/SQL

5. The DBMS Output Package

6. PL/SQL Blocks

7. Attribute

8. Operators  

9. Control Structures

10. Error Handling   

11. Composite Data Types

Solved Programs

14. Database Triggers

1. Introduction

2. Creating Triggers

3. Types of Triggers

4. Enabling and Disabling

5. Trigger Predicates

Solved Programs

15. Procedures and Functions

1. Introduction

2. Creating Procedures and Functions

3. Subprogram Parameters

4. Information on Stored Procedures

5. Procedure Overloading

6. Recursive Procedure

7. Dropping Procedures and Functions

8. Procedures Vs. Functions

Solved Programs

16. Packages

1. Introduction

2. Package Specification

3. Package Body

4. Package and Scope

5. Package Initialization

6. Recompiling the Package

7. Deleting a Package

8. Advantages of a Package

Solved Programs

17. Creating an Oracle Database

1. Introduction

2. Creating an Oracle Database

3. Managing the Oracle Instance

18. Performing Database Backup and Recovery

1. Introduction

2. Performing Database Backup

3. Performing Database Recovery

19. Moving Data

1. Introduction

2. Describe the General Architecture of Data Pump

3. Use Data Pump Export and Import to Move the Data between Oracle Databases

4. Load Data with SQL Loader

5. Use External Tables to Move Data